How can i run a query with criteria that has an apostraphe in it? I cant change the data cause it is linked to other tables by this field. Is it possible?? Any ideas of how to get around this issue? Thanks.
Aaron, if you're using Access 2000 you can use the Replace() function. What i do is check my criteria strings for single quotes then replace it with chr(44) which is an apostrophe (single quote is chr(39)) ex:
Jeff-
Yes, the criteria is coming from a combo box on a form. I actually got it figured out using the replace command. I replaced the single quote (apostraphe) with 2 single quotes and it worked.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.