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.)