Query Dates Type Mismatch Error, Access
Previously in the article Query Dates, Access I’ve explained how you can run queries on date values. However if double quotes are used in the criterion section a type mismatch error will occur. In the figure below you can see a query in design mode:
This is the criterion used:
In the article Query Dates, Access I’ve explained the different methods for defining dates in the criterion section of queries. Double quotes was not one of them. By using double quotes access will interpret the value between the quotes as a text string rather than a date value. This will result in a type mismatch error when comparing the text string value with the date values.