Rounding Error ?? !!

[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 seems to work on other numbers,
but not this one! I don't see anything in the msft
knowledge base about this.

Help!

 

[MJB1975]

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.

 

[Frank Saunders, MS-MVP]

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.

This is a common convention that I learned in college (a long time ago).

--
Frank Saunders, MS-MVP, IE/OE
Please respond in Newsgroup. Do not send email
http://www.fjsmjs.com
Protect your PC
http://www.microsoft.com/security/protect/