Using multiple "Not" criteria in a query

[steve12173]

I am running a query that I need a "Not" criteria to leave out all records
with the initials of about 10 representatives. Obviously, I can get it to
work with just of their initials (Not "g72") but, I need to filter out 10 of
these different initials.

 

[Douglas J. Steele]

WHERE Field NOT IN ("abc", "def", "ghi", "jkl", ... , "xyz")

 

[steve12173]

When I tried this, my query came up blank. This is criteria I put in: "Where
Field Not" In
("p43","h93","t79","g72","s56","h53","h38","p93","s97","t78","s84","s87")

 

[steve12173]

I got it now. I just put the criteria as Not In ("abc","def","ghi"). This
worked out perfectly.

Thanks for the help!