Need help with critera not equal to 20,30,or 40 (1 Viewer)

mrgrape

New member
Local time
Yesterday, 21:21
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
 

khawar

AWF VIP
Local time
Today, 08:21
Joined
Oct 28, 2006
Messages
870
not in(20,30,40)
 

Users who are viewing this thread

Top Bottom