How to make my query not equal to...

[katrinanyc926]

I have about 15 fields in my query and I want to narrow one field down so that it does not equal "Case1" and does not equal "Case2". I want all other cases to show up that do not have "case1" or "case2" in this certain field.



I wrote in the criteria for this field the following, but it doesn't seem to be working:

<>"case1" Or "case2"

It still returns "case2"

I have tried a lot of variations and nothing seems to work. Help, please.

[ConneXionLost]

<>"case1" And <>"case2"

[katrinanyc926]

Oh thank you! It worked!

I have another questions for you - or whoever....

How do I eliminate items when an expression is empty? In other words, I do not want records to show up if a certain expression is not calculated.

I tried typing Is Not Null in the expression's criteria, but that did not work. Any ideas on this one?

[ConneXionLost]

A field result isn't truly null if it's the result of an expression or calculation. Try using:

Not like ""