I'm getting a type mismatch message.

• Verify that the criteria you specified is for the same data type as the data in the underlying table or query. For example, the field ReorderLevel has a Number data type. Therefore, if you type the criteria "50", you'll get an error because Microsoft Access interprets values in quotation marks as text, not numbers.

  Other situations that cause a data type conflict include:

  • You're specifying criteria for a Lookup field and the criteria uses the values that display on the lookup list instead of their associated foreign key values. Because the foreign key values are the values actually stored in the underlying table, you should use them when you specify criteria for a field. For more information about Lookup fields, click .
    
    
  • You typed the dollar sign ($) in criteria you specified for a Currency field. Remove the dollar sign, and then view the results.
• Verify that the data type of each pair of joined fields in the query is the same. If not, change the data type of one of the joined fields to match the data type of the other. For more information, click .