Need help with critera not equal to 20,30,or 40

mrgrape

New member
Local time
Today, 14:42
Joined
May 23, 2010
Messages
2
Hey so im trying to make a query on a field value that is not 20,30 or 40.
Ive already made a query in which i had field values that ARE 20,30,or 40.
When i try to combine not for 20,30,and 40 it only lets me do 1.....
Such as I can only do <>20.....
if i try <>20,30,40 it wont work or even if i do <>20 <>30 <>40 it only gives me the not 20 values but still gives me 30 and 40..
If anyone can help please let me know!
thanks
 
not in(20,30,40)
 

Users who are viewing this thread

Back
Top Bottom