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!
 
Ad

Advertisements

Ad

Advertisements

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