Remove rows based on multiple fields

[k_haj]

I am looking to exclude a specific item from my query that is based on multiple fields. For example if I have a database of cars, greatly larger than shown below:

Make | Color

Ford | Red
Toyota | Blue
Chevy | Green
Ford | Black

I can't get Access to exclude only red and blue Fords.

My criteria is: Make: Not Like "Ford" | Color: Not Like "Red" And Not Like "Blue"

When I run the query it excludes all red and blue cars.

Any help is greatly appreciated! Thank you!

 

[sheetspread]

Did you try it with asterisks?

 

[xenou]

It makes more sense logically (to me anyway) to turn it into the negative form (where NOT):

select * from Table2 where not (Make = 'Ford' and Color in ('Red','Blue'))

But you can change it around using DeMorgan's Laws ........ not(x and y) is the same as (not x or not y) .......

select * from Table2 where (Make <> 'Ford' or Color not in ('Red','Blue'))

 

[k_haj]

Did you try it with asterisks?

I tried using quotes No luck.

 

[k_haj]

This is the actual SQL:
WHERE ((([OppReport for US users].CAMPAIGN_NAME)<>"Ring") AND (([OppReport for US users].SALES_STAGE) Not Like "*captured*" And ([OppReport for US users].SALES_STAGE) Not Like "*confirmed*"))

This is the actual SQL. Of course I don't have a database of cars, but I want to exclude sales stages of captured or confirmed that have a campaign name of Brava Ring. Of course there are other campaign names and sales stages.

I used the car example as it is easier to understand.

Thank you for your help, I have been trying lots of variations but nothing works.

 

[sheetspread]

wait i'll test the car example then we can apply it here

 

[sheetspread]

xenou's query does this:

Table name is Data:

Excel 2010
	A	B
1	Car	Color
2	Ford	Red
3	Toyota	Blue
4	Chevy	Green
5	Ford	Black
Sheet30

query in SQL is:

select * from Data where not (Car = 'Ford' and Color in ('Red','Blue'))

how it looks in design view:

result:

Excel 2010
	A	B
1	Car	Color
2	Toyota	Blue
3	Chevy	Green
4	Ford	Black
Sheet30