Not Not working

[tbrown]

I am trying to filter out all races at Aqu, Bel, or Sar in an Access query, but not matter how I put in that criteria, I keep getting all those records.
Help says to use Not "Aqu" or Not "bel" or Not "sar", but that dosn't work.
Any suggestions?

Thanks

[Rick]

Try

Not "aqu" or "bel" or "sar"

[Donnie]

or try the words

Not Like "AQU" or Not Like "Bel"

[MikeDee]

I think you need to use the "and" connector rather then the "or"

try
<>aqu and <> bel and <> sar

[Rick]

My book says the solution is

Not ("aqu" or "bel" or "sar")

[Victor]

MikeDee's way works for me.

[tbrown]

Thanks, guys.
Both ways work.

[MVMcKee]

Not "aqu" or "bel" or "sar"

Maybe it's late, but I read the above as :
Give me everything except Aqueduct.
Does the NOT carry forward to Belmont and Saratoga?

[Rick]

Yes. But the book says to use the brackets.

A quick test shows it works just like you have it.