Round function quandary

[MJB1975]

SELECT Round(4666.5,0) AS Expr3, CDbl(FormatNumber
(4666.5,0)) AS Expr1
FROM CAMPS;

This is producing 2 different results (4666 and 4667
respectively). Why isn't the round function working to
round this number up?!

It looks like Access (and Visual Basic) are rounding even
numbers down (2.5, 4.5, 6.5 etc) and odd numbers (1.5,
3.5, 5.5 etc) up! I've never heard of that before, and I
don't know if they have always been doing that?! I guess
it will supposedly even out the overall rounding scheme.

 

[MJB1975]

This is the result of Banker's rounding vs. Arithmetic
rounding.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;194983&Product=vb6