How can I eliminate certain data from a query criteria?

[net]

Hello,

Is it possible to create a criteria in a query to pull specific data and eliminate other specific data at the same time?

This criteria is working well to output all Apples, Oranges and Pears. But, in the list is data with “Pears Today” and I don’t want the see “Pears Today”.

How can I eliminate pulling "Pears Today" from my data?

I am currently using the following criteria and it works great to pull the specific data.

Like "Apples*" Or Like "Oranges" Or Like "Pears"

I am using Microsoft Access 2013.

Appreciate your any help. Thank you.

 

[pbaldy]

Try

(Like "Apples*" Or Like "Oranges*" Or Like "Pears*" ) And <> "Pears Today"

I'm guessing you dropped the wild cards by mistake.

 

[net]

Hi pbaldy,

Thank you so much for responding. I tried your structure, but it is still not working.

Sorry, I want to eliminate all other items associate with "Pears Today". So, I don't want to see "Pears Today 1, "Pears Today 2", etc.

 

[net]

Oh, I used this and it works. Yaaaa!

(Like "Apples*" Or Like "Oranges*" Or Like "Pears*") And Not Like "Pears Today*"

Thank you again for your help.

 

[pbaldy]

No problem.