select between numbers

[Mary]

I am working on a database with negative numbers, I want to be able to
1) select between a set of negative numbers

 

[Michel Walsh]

You have probably hit the enter key before the end of your message.

If you really want to select between two values, both negatives, or not,
just specify them, in ANY order:


BETWEEN -25 AND -10

or

BETWEEN -10 AND -25


With Jet, it does not matter if the left value is smaller, or larger, than
the right value.



BETWEEN 1000 AND 10


will return the same as


BEWTEEN 10 AND 1000


with Jet.



Vanderghast, Access MVP

 

[John W. Vinson]

I am working on a database with negative numbers, I want to be able to
1) select between a set of negative numbers

Fine; what problem are you having doing so?

As Michel says, a criterion "BETWEEN -100 AND -90" will work just fine; you
can also use