To troubleshoot this message, try the following:
- Verify that the criteria (criteria: Conditions you specify to limit which records are included in the result set of a query or filter.) for a column matches the data type (data type: The characteristic of a field that determines what type of data it can hold. Data types include Boolean, Integer, Long, Currency, Single, Double, Date, String, and Variant (default).) of the column's underlying field. If you specify a text criterion for a numeric or date/time field, you will get this error. For example, the field ReorderLevel has a Number data type. Therefore, if you type the criteria "50", an error message will be returned because Microsoft Office Access 2003 interprets values in quotation marks as text, not numbers.
Other situations that cause a data type conflict include: