error "data type mismatch in clriteria expression!"

[Alla]

I am writing a query in Access2002. In one field text data
type was converted to the number, but serching for the
data grater than a particular number (e.g.>100) brings an
error message "data type mismatch in criteria
expression!". It doesn't happen in Access97. Does it have
anything to do with the fact that Access97 and Access2002
were both installed on my PC? Uninstalling Access97 didn't
solve the problem.

 

[Van T. Dinh]

Try type-casting the Field value to the appropriate type for comparison. For
example, you can use something like:

....
WHERE Val([TextFieldMeantToBeNumeric]) > 100