not = to in a query

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have a query and I would like not to include 142, 20441,16, and 101 from a
field named CLT_ID. What would I need to put in the criteria in order to get
all the results with out the above?
Thanks
 
I have a query and I would like not to include 142, 20441,16, and 101 from a
field named CLT_ID. What would I need to put in the criteria in order to get
all the results with out the above?
Thanks
Click to expand...

NOT IN( 142, 20441,16,101)
 
Back
Top