how do u use like in Access, it doesn't seem to work?
L Lynn Trapp Oct 9, 2003 #2 LIKE does a comparison of string values. You need to use it with a wildcard, though. Where YourTextField LIKE "SomeValue*" or Where YourTextField LIKE "*SomeValue" or Where YourTextField LIKE "*SomeValue*"
LIKE does a comparison of string values. You need to use it with a wildcard, though. Where YourTextField LIKE "SomeValue*" or Where YourTextField LIKE "*SomeValue" or Where YourTextField LIKE "*SomeValue*"
