Access Remove rows based on multiple fields

Aug 25, 2016
Reaction score
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!
Jul 11, 2010
Reaction score
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