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 first-name value of "Richard's". Just include double double quotes.

         dcount("[first-name]","table-name","[first]=""Richard's""")

Happy Coding

 
Note: This web site dedicated to MS Access database users is an independent publication of Richard W. Killey and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft® Corporation.
 

© 2006, 2007, 2008 Richard W. Killey. All Rights Reserved. - Privacy Policy