the Manx Man's MS Access Pages

Searching for a String that Includes a Quote (009)

If you have data that includes single quotes, here is the way to get around problems.

For example, I need to search for an entry with a value of "Richard's". Just include double double quotes.

         dcount("[first]","propercase","[first]=""Richard's""")