Access 2010 Between statement returns both positive and negative values
Posted on 2013-12-27
I am using a between statement to pull 2 values from a text box in a form and return the fields that are between these values. The field in question is a calculated field in another query and is joined to this query. My problem: my statement is treating the values as absolutes and is returning those in the between range that are both positive and negative.
For example, I have values that are 255, 376, 115, 543, -36, -125, -444. If I send values to the between statement that are between 200 and 400, I get 255, 376, 543, and -444.