January 14th, 2013, 03:58 PM
Access 2010 Web database - Query criteria
In a very simple web database in Access 2010, I want to set a criteria for someone's name eg "Andrew". Typing those characters into the criteria box and clicking on Run brings up an error message "Data type mismatch in criteria expression". If I remove the criteria and run the query, it happily brings up the record with the name Andrew. I've tried putting an = sign in front but it makes no difference. Any ideas would be much appreciated. Thanks.
January 15th, 2013, 07:25 AM
What is the data type of the field you are searching. The error indicated that you are trying to use text criteria on a field that is not text. Make sure you're field is not a memo field. I do not believe you can use criteria on a memo data type.
Can you post the SQL for your query?
January 15th, 2013, 10:38 AM
Many thanks for your response. You're right - the criteria had to be placed in the field that was being looked up. The datatype in the main table was "Lookup & Relationship", so I guess that's why it wouldn't accept the text in the criteria. This Access web database is another learning curve altogether! Thanks again for your help - greatly appreciated.