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.