Rounding Error ?? !!

  • Thread starter Thread starter MJB1975
  • Start date Start date
M

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!
 
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 said:
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.
Click to expand...

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/
 
Back
Top