I'm creating query to list people with their countries, and...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to NOT list two of those countries. I tried "Not England or France"
and <>country name in the criteria. What should I put to list all countries
and not this one and this one. Thanks!
 
It is working. But you said not England OR France. This will always be
true. You need to say:

NOT England AND NOT France.


Rick Bear
 
I need to NOT list two of those countries. I tried "Not England or France"
and <>country name in the criteria. What should I put to list all countries
and not this one and this one. Thanks!
Click to expand...

Rick's answer is spot-on; an alternative syntax (better if you have
several countries) is

NOT IN("England", "France")


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Rick B said:
It is working. But you said not England OR France. This will always be
true. You need to say:

NOT England AND NOT France.
Click to expand...
Rick, Thank you! This did the trick! Debbie
 
John, I have put your answer in my notes for future reference. Thanks so much
for your help!

Debbie
 
Back
Top