Please Help With A Query <> United States or US

[NYFashionToGo]

I am trying to build a few queries here. This is the situation I am spliting up Invoicing into 2 parts Domestic and International. On my domestic query I typed in the criteria box "United States" Or "US Or APO/FPO. It worked perfectly. When I went to do my International Query In the criteria box I typed in <>"United States" Or "US Or APO/FPO , I do get the other countries But I still get US and APO/FPO as output... Not sure how to resolve this. Can anyone assist.

Thanks

 

[NYFashionToGo]

Okay I just ran a 3 seperate queries off the original one and it worked, But is there a way to simplify it into one query. Just trying to learn here....

Thanks

 

[SuicidED]

use "and" instead of "or"...hopefully

 

[NYFashionToGo]

2nd thing I tried and it did not work that way either

 

[SuicidED]

<>"united states" And <>"us or apo/fpo".....

 

[lespaul]

how about:

NOT IN ("United States","US Or APO/FPO")

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[traingamer]

Aren't those three separate criteria?
to include:

"United States" Or "US" Or "APO/FPO"

to exclude:

<> "United States" AND <> "US" And <> "APO/FPO"

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[NYFashionToGo]

Thanks everyone for the Input, I think I see what I was doing wrong now.

I was doing this:

<> "United States" AND "US" And "APO/FPO"

Instead of This:

<> "United States" AND <> "US" And <> "APO/FPO"

That works perfectly fine on one query.

Thank you so much.

 

[lespaul]

again, the syntax

NOT IN ("United States", "US", "APO")

will accomplish the same thing as

<> "United States" AND <> "US" And <> "APO/FPO