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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using check boxes to select criteria to run query 2
Prompt user for a list of values in a query 1
Query to merge text values from two columns and DLookUp text value in another table 4
create 1 field from multiple records 1
how to allow the user to enter their search criteria 2
query help 5
Query help 2
how make a select with a AND in columns 1

Back
Top