Access Remove rows based on multiple fields

Joined
Aug 25, 2016
Messages
2
Reaction score
0
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!
 
Joined
Jul 11, 2010
Messages
5,758
Reaction score
552
Sorry khjaenga I cannot help you on this matter, but I am sure one of our members will be able to help. Welcome to PCR enjoy and participate:thumb:
 

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

Top