Use of "Not" in query

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I would like for a query to return all results EXCEPT for
two items in a field named "Building". In the Criteria
row I put

Not "Item1" OR Not "Item2"

If I put set the Criterion as not either one of the two,
it excludes the one I indicate. However, I can't seem to
get it to exclude both. I tried it by putting the criteria
both on one row, as shown above, or by putting each item
into its own row. Either way, I can only seem to exclude
one item, not both.

I'm sure this is simple...but then, perhaps I am, too!
 
Use AND not OR
Not "Item1" AND Not "Item2"
Another alternative
Not In("Item1","Item2")
 
Back
Top