Still learning criteria...need help!

[Guest]

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!

 

[Guest]

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!

 

[Guest]

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?

 

[Guest]

Yes, I have tried that and it only recognizes the first item in the list.

 

[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.