Why am I getting a data type mismatch in criteria message when I t

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

Guest

Why am I getting a data type mismatch in criteria message when I try to do a
query? I tried checking the properties of the data already, as suggested by
the trouble shooting info provided by the help menu in Access. The data I'm
using is all text.

Thanks.
 
pleasehelp said:
Why am I getting a data type mismatch in criteria message when I try to do a
query? I tried checking the properties of the data already, as suggested by
the trouble shooting info provided by the help menu in Access. The data I'm
using is all text.
Click to expand...


You're probably missing quotes around the criteria values.
 

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

i am getting the message "Type Mismatch" 1
data mismatch 2
Data type mismatch in criteria expression 5
Data Type Mismatch 2
"Data type mismatch" without any criteria! 6
Error: Data type mismatch in criteria expression 0
data type mismatch 3
'Data type mismatch in criteria expression' error in Count query 2

Back
Top