Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access Data Type Mismatch in Query

Hi

I am getting the following error in the image.If I remove the <>5 I still get it

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Hi
I looked in the query and the table and it is an AutoNumber field
User generated imageUser generated image
Avatar of Norie
Norie

Do you have any problem running the query?
Hi. The query runs just fine

User generated image
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for the help. I played around with the queries and found that there were errors