Margaret has attended:
No courses
Queries
When I enter " " around a text word to have the query only display that information, I receive a message that the criteria does not match. I noticed in the design page that I had this listed as a number but it is text. I can't change it now as there are many relationships to many tables. So, how can I get this to be accepted and run the query?
RE: Queries
Hi Margaret:
If the field is shown as a Number data type in Table Design view, then it will only accept numeric data, not text data.
Thus, in a Query Criteria you have to enter a numeric value. A number enclosed in quotes - "123" - will not work, you will get a Data Type Mismatch Error message. You need to enter the number without the quotes.
Regards,
Tony
RE: Queries
Thanks Tony, When I enter it with no quotes, Access adds the quotes then gives me the same error. M
RE: Queries
Hi Margaret, perhaps you could post your 'criteria' line so that we can have a quick look and see if there is anything that could be 'tweaked' to help with your problem, look forward to hearing from you, regards Pete
