Need help with a very simple query (List-of-Values-Match)

Markv

New member
Local time
Yesterday, 23:29
Joined
Oct 18, 2009
Messages
2
I have the following table:

12279053.jpg



When I try to use the List-0f-Values-Match to make a query using the: In ("20","30","40") criteria in the Monthly Fee field, I get the "Data type mismatch in criteria expression. (Error 3464)"

Here is the query in design view:

s3luu1.jpg


I don't understand what am I doing wrong?
 
Nevermind. I fixed it by removing the quotation marks
 

Users who are viewing this thread

Back
Top Bottom