Multiple Criteria in query not working

[avarusbrightfyre]

I can run my query with one criteria just fine, but when I have two "event" criteria it simply ignores them both. Strangely, it still runs the date criteria. Here is what I have:



Date Event
>Date() Not "Event"
>Date() Not "Event2"

I've also tried <>"Event" which returns the same results. Am I missing something stupid or basic? I've been doing this a while and never had a problem with multiple criteria queries.

[AccessMSSQL]

If you have any other criteria set in your query you may need to copy the criteria down to the 2nd row in the query grid. OR keep both criteria on one line. Can you paste your query statement?

[avarusbrightfyre]

I guess I missed something basic. I ended up with this:

>Date() in the date block and Not "Event1" And Not "Event2"

I was trying to say Not "Event1" or "Event2". For whatever reason, using the word and plus adding another "not" seems to work. Why doesn't just putting "or" between them work?

[AccessMSSQL]

You can't use OR if you are trying to exclude both values. Your original query would be the equivalent of returning records first where Date > Date() and not Event1 (this would return Event2 records). and vice versa for the other statement. Hope that makes sense!