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 - 15 May 2006 10:57 GMT
Try this FieldName:Round(Number [,5])

Signature
Wayne
If you feel this answer has been useful please check the "was this post
helpful" so I get some feedback. Thanks.
> 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
[quoted text clipped - 5 lines]
> i get what I wanted? I am a new user in Access, so any help will be
> appreciated.