How to use round function?

[Azy]

I have a table with a field >0 and <99999 (decimals are allowed). And since
I have to export this table to a fixed-width ACII file, and this field has to
be length of 5, I created a query and tried to use
"newfieldname:round(oldfield name, 5) to make the length of the filed = or
<5. Most of the number is ok, but I got some wired numbers . For example,
the value 0.15 was changed to 0.150000005960464, and 0.6 became
0.0599999986588955. Could somebody tell me somewhere i did wrong and how can
i get what I wanted? I am a new user in Access, so any help will be
appreciated.

 

[Wayne-in-Manchester]

Try this FieldName:Round(Number [,5])