Type Mismatch in expression error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What does the error "Type Mismatch in expression" mean and what can I do
differently?
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access visual basic program 'type mismatch' error 1
How to SELECT with date criteria by SQL? 1
Replace Function and Data Type Mismatch in Results 7
Access error message: "Data type mismatch in criteria expression" 5
Access 2000 Question 1
Data type mismatch 3
Query- Type Mismatch In Expression 2
Data type mismatch in criteria expression 1

Back
Top