Access 2010 Web database - Query criteria

[Andrew Thorpe]

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.

[meratigoerr]

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?

[Andrew Thorpe]

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.