Using multiple "Not" criteria in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve12173 - 23 May 2008 21:16 GMT

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.

Reply to this Message

Douglas J. Steele - 23 May 2008 21:22 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

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

Reply to this Message

steve12173 - 23 May 2008 21:37 GMT

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")

> WHERE Field NOT IN ("abc", "def", "ghi", "jkl", ... , "xyz")
>
[quoted text clipped - 3 lines]
> > of
> > these different initials.

Reply to this Message

steve12173 - 23 May 2008 22:42 GMT

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

Thanks for the help!

> When I tried this, my query came up blank. This is criteria I put in: "Where
> Field Not" In
[quoted text clipped - 7 lines]
> > > of
> > > these different initials.

Reply to this Message