Access is incorrectly rounding numbers that end w/ .50 down

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I am using Access 2000. When I round numbers that
have .50 access incorrectly rounds them down. If it ends
in .51 it rounds up correctly. It is just .50. Does
anyone know of a way to fix this?
 
I am using Access 2000. When I round numbers that
have .50 access incorrectly rounds them down. If it ends
in .51 it rounds up correctly. It is just .50. Does
anyone know of a way to fix this?
Click to expand...

Access uses "Banker's Rounding". Values with a fractional portion of
exactly 0.5 round to the nearest even number (e.g. 1.5 and 2.5 both
round to 2.0). This is so that the average of a large number of
rounded values is approximately equal to the average of the original
numbers, rather than being systematically larger.
 
Add a tiny bias value before rounding. For example, if you raw numbers have
2 decimal places, use Bias = 0.001.

For example (from the Debug window):

Bias = 0.001
?Round(2.50 + Bias)
3
 
Back
Top