queries using the not command with more than one item

  • Thread starter Thread starter access query question using not
  • Start date 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?
 
A couple of ways --
<>"Sam" AND <>"Joe" AND <>"Bill" AND <>"Jack"
Not In ("RED","WHITE")
 
Back
Top