not between operator not working

  • Thread starter Thread starter Cricri
  • Start date Start date
C

Cricri

Hi, I am trying to query my data and I want to exclude a whole bunch of
values. However when I use not between x and y, it still includes it.

I am using MS Access 2007

Any idea?
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here. Also some examples of the data that isn't being
exluded.
 
Oh! Not Between "x" And "y" will not get rid of anythign starting with y or Y.

This will:

Not Between "x" And "z"
 
Back
Top