query filter... should be simple...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good day all..

I'm trying to filter or "criteria " my query so that it excludes "Sample"
and "Strike-Off" within the ordertype criteria.... how ever if I try <>
"Sample" or "strike-Off" the filter only filters the "sample" ordertype.

Can anyone help on how I can include both "sample" and "Strike-Off"?

Thanks,

Brook
 
Brook,

Try:

<> "Sample" And <> "Strike-Off"

Or:

Not In ("Sample", "Strike-Off")

HTH,
Nikos
 
Nikos...

thanks for the response...

The first option didn't work, but the second option did.

Brook
 
Back
Top