queries using the not command with more than one item

  • Thread starter access query question using not
  • Start date
A

access query question using not

trying to do a query using not "example" or "example"

can on ly get this to work with one item, not more than one

need to say not abouit 8 items

how do i do it?
 
K

KARL DEWEY

A couple of ways --
<>"Sam" AND <>"Joe" AND <>"Bill" AND <>"Jack"
Not In ("RED","WHITE")
 

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

Top