not between operator not working

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

 

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

 

[ghetto_banjo]

instead of "not between x and y", how about:


<x AND >y

 

[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"

 

[ghetto_banjo]

are x and y variables holding numerical values or actual string
values?