Query is rounding up when it shouldn't

[Richard Hollenbeck]

I have a criteria set as ">=82.00 And < 92.00" in a query that returns
records with values like 81.999 because, apparently, it is rounding up. How
can I get it to truncate the value to two decimal places rather than
rounding it up?

 

[Tom Ellison]

Dear Richard:

I'm going to guess you could try these two things.

Try >= 82.0000 and < 92.0000. It may be rounding to the precision of
the target values. Also, the greater precision values may force
conversion of the source value to a different type before conversion.

Try >= CDbl(82) and < CDbl(92). This also may change how the source
value is converted before comparisons.

Please let us know if either or both of these work.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts