not = to in a query

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
 
J

John W. Vinson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Incone & Expenses Statement 0
Data consolidation 0
Finding Matching data 6
Union query 5
Work Budget Salary vs Real Time Salary 0
Passing multiple criteria to query a table 2

Top