I am using the Round function in a query to display a number field in a table to 2 decimal places, but it returns a number with about 10 decimal places. Please could anyone tell me why this is?
Example:
In a table there is a field called 'Num' which is of number type 'Single'. A value in this field is 39.553.
I want to show the values in 'Num' to 2 decimal places, so I use the query
SELECT Table1.Num, Round([Num],2) AS Rounded
FROM Table1;
But this query returns 39.549999237 when Num=39.55, 39.553 etc.
Why doesn't it return 39.55?!
I can get round this by changing the Round expression to Round(CDbl([Num]),2) but shouldn't the simpler version work?
Thanks for any help!
Steve
Example:
In a table there is a field called 'Num' which is of number type 'Single'. A value in this field is 39.553.
I want to show the values in 'Num' to 2 decimal places, so I use the query
SELECT Table1.Num, Round([Num],2) AS Rounded
FROM Table1;
But this query returns 39.549999237 when Num=39.55, 39.553 etc.
Why doesn't it return 39.55?!
I can get round this by changing the Round expression to Round(CDbl([Num]),2) but shouldn't the simpler version work?
Thanks for any help!
Steve