Type Mismatch in expression error

Z

Zues84

What does the error "Type Mismatch in expression" mean and what can I do
differently?
 
O

Ofer

You are trying to assign a value type to a different type of a field, it can
also can be in a critria when you trying to filter a field with a different
type
e.g

Filter a number field with a string field.
If you post the code or the sql we will be able to help you more.
 
D

Douglas J. Steele

It means you're trying to do something with two different types of values,
when they should both be the same type. A common example is trying to
compare a number to a text value in a query, or assigning a text value to a
numeric variable.

Without seeing the code that's causing your error, that's about as specific
as I can be.
 
Top