"Or" and "Not Like" Operators

[fscheer]

I have built this very basic query in which I want to filter out a few records. I have attempted several versions of the Not Like "xxx" Or "yyy" or "zzz" criteria (all in the same criteria line, in different lines, in different instances of the same field, etc.) The best I get is the first record specified in the expression filtered out. I have done these before, and don't know why it is not working now. To test that I was sure I was correct in my procedure, I tried the same Not Like expression in a backed up version of the same DB (made a couple days ago), and it worked. When I imported that query into my current DB, it failed to work correctly.
I hope this explains my problem well enough, and I would be appreciative if anyone had any thoughts!
Thanks.

 

[jwindon]

It sounds like you need to look at your joins. You may have them going the wrong way.

 

[Jack Cowley]

If it works in one db but not the other then I would suggest importing all of the tables, queries, forms etc. from the non-working db into a new empty one. That may clear up your problem....

 

[fscheer]

jwindon: The query is a simple filter query, off one field in one table, so there are no joins.

Jack Cowley:
I tried importing to a clean db...that did not work.

I forgot to mention that I tried the Not In ("xxx", "yyy", "zzz") expression, and that does work, but it's not as convenient because you can't use wild cards with that expression.

 

[fscheer]

Thanks...using And instead of Or did work. But it still doesn't make sense why using Not Like...Or...Or... DID work on one of my databases (just as the Not Like...And.... worked).

Thanks again.