Multipe nots

[teiben]

I'm uisng a crosstab query to give me the top 10 rejects in a query. I want to omit "various", "none" and "unknown"

I can get the criteria to not show "various" by using Not "unknown" but when I try and add none and unknown to the statement they show anyway, I've tried

Not "unknown" Or "none" or "various" and
Not "" with , and ; in between and nothing works.

I tried searching not in this section and there were none with the keyword not, Can I be the only one?

 

[boblarson]

The criteria should read:

<>"unknown" AND <> "none" AND <> "various"

 

[pbaldy]

Another way:

NOT IN ("unknown", "none", "various")

 

[teiben]

Not In ("unknown","none","various") works like a charm

Thanks