Query using multiple <> criteria across multiple fields

[bcirka]

I have a simple table:

ID	Field1	Field2
2	Brian	Blue
3	Brian	Yellow
4	John	Yellow

I want to query it where it selects those records that do not equal "Brian" in Field1 AND do not equal "Blue" in Field 2. My SQL code is below (interpreted from MS Access' GUI).

SELECT Table1.Field1, Table1.Field2 INTO test
FROM Table1


WHERE (((Table1.Field1)<>"Brian") AND ((Table1.Field2)<>"Blue"));

When I run the query, it results in :

Field1	Field2
John	Yellow

Whereas I expect it to pull BOTH the bottom two records. Can anyone assist?

(N.b. This is an example of a dataset that I am try to similarly query, but it has a few million rows.)

[ranman256]

Then you want a different logic...OR.. if you can have BRIAN but not YELLOW.

field1 not brian
or
field2 not Yellow
put this on separate criteria lines
--------------------------
not brian

--------------------------

not yellow

---------------------------

[bcirka]

Thanks for the response. I guess I'm still having a conceptual problem with this. If I only want to exclude the records which contain "Brian" (Field1) AND "Blue" (Field2) , then why would I use OR? It seems to me that OR would be used if I wanted to exclude records where Field1 = "Brian" or Field2 = "Blue".

[bcirka]

To add to my last comment:

The statement below works (I pulled it out of MS Access' SQL, and cut down on someone of the syntax for better readability in this post). Now, I'm looking for the EXACT OPPOSITE of this statement. I want to exclude all 'Outbound shipments out of Testville'. Just not sure how to make this work, or what to put in which line.

WHERE ((([Origin City]="Testville" Or ([Origin City] Is Null) AND (([Transportation Type Description])="Outbound" Or [Transportation Type Description] Is Null));