<>

  • Thread starter Thread starter Exaviour
  • Start date Start date
E

Exaviour

Hello, I wrote a query to show 20 different values in one particular field
which works fine, but now I want to show everything but those values, so I
wrote another query as followed.
<> "value" or "value" or "value" .........
But those values are still showing up? Should be quite simple but I'm
stumped

Thanks
Exaviour
 
Hi,


NOT IN( value1, value2, value3, ... )


Clearly, if x = 22, then
x<>22 OR x<> 33
is true, so the initial statement is always true.


Hoping it may help,
Vanderghast, Access MVP
 
Hi:

criteria should be

is not like <value1>
is not like <value2>

etc
..
..
..
..
listed under the field in the query
 
Thanks
what worked was, Not ( "value1" or "value2" ..... )
Thanks for the quick response

Care to elaborate on your explanation, Not sure I thoroughly understand.
 
Back
Top