not between operator not working

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?
 
J

Jerry Whittle

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.
 
J

Jerry Whittle

Oh! Not Between "x" And "y" will not get rid of anythign starting with y or Y.

This will:

Not Between "x" And "z"
 
Top