Not Criteria

  • Thread starter Thread starter Delaina Lyons via AccessMonster.com
  • Start date Start date
D

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.
 
Delaina Lyons via AccessMonster.com said:
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.
Click to expand...

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