Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
January 14th, 2013, 02: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, 06: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, 09: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.
By lkallas in forum Visual Basic Programming
Last Post: August 28th, 2012, 04:30 PM
By DoctorPDR in forum Microsoft Access Help
Last Post: December 7th, 2011, 10:35 AM
By chrisjack001 in forum Microsoft Access Help
Last Post: February 22nd, 2011, 11:15 AM
By mamaStone in forum Microsoft Access Help
Last Post: August 23rd, 2006, 07:22 AM
By Beagles in forum Microsoft Access Help
Last Post: January 9th, 2006, 05:24 PM