Having trouble creating using criteria which excludes more than one type

[accessmatt]

Hello,

I'm having trouble excluding "Apples" AND/OR "Pears" using a query of my table. I can only seem to exclude one at time with NOT. See screenshot of my query.

[burrina]

Try this:

Not Like "*Apples*"
Not Like "*Pears*"

HTH

[accessmatt]

Dave, unfortunately that didn't work.

[burrina]

Hmm, Worked for me.

[June7]

You want to exclude all records that have either Apple or Pear?

Maybe:

Not In ("Apples", "Pears")

[accessmatt]

Nailed it June7, that worked, thanks!