To prevent an email system from blocking an mdb, I have the user remove the "b" from the mdb extension. I restore it on receipt, then open it. (And vice versa.) Probably the recipient automatically opened the "txt" file in Notepad instead of renaming it.
You can also produce the kind of SQL Golom gave you by typing on the criteria line of the query design grid:
Not Like "Albany" And Not Like "Rochester" And Not Like "Syracuse" or
<>"Albany" And <>"Rochester" And <>"Syracuse"
(Add as...
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.