I use the Function ROUND Round(0.5) =0 ------why? the right answer is 1 , who can explain?
H Help Dec 10, 2004 #1 I use the Function ROUND Round(0.5) =0 ------why? the right answer is 1 , who can explain?
R Rick Brandt Dec 10, 2004 #2 Help said: I use the Function ROUND Round(0.5) =0 ------why? the right answer is 1 , who can explain? Click to expand... "right" according to whom? Access uses Bankers Rounding which always rounds to the even digit on the half, not "always up" which is less accurate when rounding lots of numbers.
Help said: I use the Function ROUND Round(0.5) =0 ------why? the right answer is 1 , who can explain? Click to expand... "right" according to whom? Access uses Bankers Rounding which always rounds to the even digit on the half, not "always up" which is less accurate when rounding lots of numbers.
B Brian Dec 10, 2004 #3 Help said: I use the Function ROUND Round(0.5) =0 ------why? the right answer is 1 , who can explain? Click to expand... Yeah, I learned that at school too! Anyway, detailed explanation and alternative rounding functions can be found here: http://support.microsoft.com/default.aspx?scid=kb;en-us;196652
Help said: I use the Function ROUND Round(0.5) =0 ------why? the right answer is 1 , who can explain? Click to expand... Yeah, I learned that at school too! Anyway, detailed explanation and alternative rounding functions can be found here: http://support.microsoft.com/default.aspx?scid=kb;en-us;196652
