How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?

The criteria expression is the part of the query containing the conditions, as in WHERE <condition>. Look at those specifically. The error message means you’re comparing two things (this equals that, or this less than that, etc.) that are of two different, and incompatible types (comparing a number to a string, for example). You can find … Read more