Still learning criteria...need help!

K

Kristin

I have a table of about 1,000 different job titles and would like to run a
query with all but 7 of them. I can use Not to exclude one of the job
titles, but can't find how to exclude all 7 in the same query. Is this
something that can be done? Please help, I think I have read every box I can
and I still haven't found anything to solve my problem!
 
A

april

Kristin said:
I have a table of about 1,000 different job titles and would like to run a
query with all but 7 of them. I can use Not to exclude one of the job
titles, but can't find how to exclude all 7 in the same query. Is this
something that can be done? Please help, I think I have read every box I can
and I still haven't found anything to solve my problem!
Click to expand...
 
A

April

Have you tried putting a different criteria on each line in the same column
that would account for each of the titles that you would like to exclude?
 
V

Van T. Dinh

Check the JET SQL Reference section in Access Help on the "In" operator.

You can use "Not" with "In" like:

.....
WHERE [MyField] Not In (1, 2, 3)

which will not select Records with [MyField] values equal 1, 2 or 3.
 
Top