Not Criteria

[Delaina Lyons via AccessMonster.com]

Ok, I am having major issues here..I think I might be working too
much..haha
Anyway..My problem is that my query wont filter my Column LastResult. I
need any record under that column that says "NONE" or "Voice Connect" to
not show up. I tried using the Not function, but it wasn't working!
Any help would be appreciated.

 

[Wayne Morgan]

Try

Not "None" And Not "Voice Connect"

or

Not ("None" Or "Voice Connect")

 

[Rick Brandt]

Ok, I am having major issues here..I think I might be working too
much..haha
Anyway..My problem is that my query wont filter my Column LastResult. I
need any record under that column that says "NONE" or "Voice Connect" to
not show up. I tried using the Not function, but it wasn't working!
Any help would be appreciated.

Not is for True/False. You need to use <> (not equal).

 

[John Spencer (MVP)]

Try criteria similar to:

NOT IN ("NONE","Voice Connect")