"Not" criteria works for one line, but not two

[avarusbrightfyre]

As the title states, I am unable to use a Not "this" statement in my query criteria for more than one item.

My specific problem is I'm trying to do this:

Date Organization Event
>Date() Not "This" Not "This"
>Date() Not "This" Not "This"

If I do just one "not" criteria for each item, it works fine, but doing it for both doesn't work for either. If I put them both in the same line using an "or" between the values I don't want, it works for one but not the other.
I tried creating a new query to rule out any corruptions, but it still does the same thing.



What is the proper procedure for exluding multiple text values from a field and showing all the others? The program automatically converted my "Not" to "<>" when I reloaded the program, so I've already tried using that.

[boblarson]

For Text you would use <> and if you want an OR (it is greater than the current date AND Org doesn't equal "This" OR the date is greater than the current date AND Event doesn't equal "This" would be:

  Date         Organization           Event
>Date()        <> "This" 
>Date()                              <> "This"

If you want the date to be greater than the current date And Org AND Event to not be equal to "This" then it would be a single line:

  Date         Organization             Event
>Date()        <> "This"               <> "This"

Now, one thing to be wary of. Using DATE as a field name or object name is not good. That is an Access Reserved Word and it may come back and bite you at the most inopportune times. I would not use it as a name.

Oh, and make sure you know that >Date() means it would be TOMORROW or Greater. It does not include today.