How do I exclude information from a Query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can get it to show the 3 items but I can't get it to show everything except
those 3... I don't know VB so I was trying to see if I could use the Not
function. It only discludes one of the items I tell it too, not all.
 
Hi,


The criteria can be:

NOT IN(1, 10, 11, 12)


to exclude the records where the field value is one of the supplied values
in the IN-list.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top