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

D

Debbie

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!
 
R

Rick B

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
 
J

John Vinson

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
 
D

Debbie

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
 
D

Debbie

John, I have put your answer in my notes for future reference. Thanks so much
for your help!

Debbie
 
Top