I have a table that I am querying with MSQuery. It has a field NAMES that has a group of entries like "Do not use", "Do no use" "Do not use, Delete?" and other misspellings of these.
I am hoping I can leave these behind by using syntax like <> Like 'Do not use %' In the criteria field of NAMES. I have tried many versions of this after reading the ms help files but I always get "Syntax error" If I just use <>"Do not use" the query works. Can somebody help me get it right?
John
Bookmarks