The ROUND Function is not rounding #.5 to nearest whole number

The ROUND Function is not rounding #.5 to nearest whole number

Post by Dirk Goldg » Thu, 14 Dec 2006 05:04:16



This is the expected and intended behavior of the Round() function in
Access, which uses "banker's rounding" to minimize the effect of
rounding error. When rounding the digit 5, it rounds to the nearest
even number. So Round(1.5) = 2, and Round(2.5) = 2. This "evens out"
the skewing effect of repeated roundings. If you want to overrule this
behavior, you have to use your own custom rounding function; you'll can
find one posted here:

http://www.yqcomputer.com/

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)