Round Function in Access

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I need some help resolving a problem I have found with
this function. Here is the problem I have run into: the
calculation 0.75 * $13233.58 = $9,925.1850. When I use
the ROUND function in Access it returns $9,925.18. When I
use the same function ROUND in Excel it returns $9925.19.
I know in Excel there is a Roundup function but that
rounds every number up. Does anyone know why these
fucntions don't produce the same results. ANy advice?
Since I am dealing with hundreds of numbers those pennies
in currency begin to add up.

Thanks for your help.
Brian
 
Brian said:
I need some help resolving a problem I have found with
this function. Here is the problem I have run into: the
calculation 0.75 * $13233.58 = $9,925.1850. When I use
the ROUND function in Access it returns $9,925.18. When I
use the same function ROUND in Excel it returns $9925.19.
I know in Excel there is a Roundup function but that
rounds every number up. Does anyone know why these
fucntions don't produce the same results. ANy advice?
Since I am dealing with hundreds of numbers those pennies
in currency begin to add up.
Click to expand...

Access uses "Banker's Rounding" where the (5) is rounded towards the
nearest even number rather than "always up" or "always down". The theory
is that when rounding occurs on a large column of numbers approximately
half the fives will round up and approximately half will round down. That
way the grand total at the bottom is more accurate. If you always round in
one direction then the rounding errors accumulate instead of canceling.
 
Use Format() to overcome the banker's rounding that Access
employs.

e.g., Format(123.41283, "0.00")

David Atkins, MCP
 
Dear all

I've relised that once I use format function in my query, I need to register new Access 2000 ActiveX control into my machine in order to run the query. Why

Thank you

Best regards
Fion H

----- GreySky wrote: ----

Use Format() to overcome the banker's rounding that Access
employs

e.g., Format(123.41283, "0.00"

David Atkins, MC
 
Back
Top