M Mary May 14, 2009 #1 I am working on a database with negative numbers, I want to be able to 1) select between a set of negative numbers
I am working on a database with negative numbers, I want to be able to 1) select between a set of negative numbers
M Michel Walsh May 14, 2009 #2 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
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
J John W. Vinson May 14, 2009 #3 I am working on a database with negative numbers, I want to be able to 1) select between a set of negative numbers Click to expand... 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
I am working on a database with negative numbers, I want to be able to 1) select between a set of negative numbers Click to expand... 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
