Exporting Number with Decimals to Text Rounds to 1 decimal place

[Craig Walker]

I have data in Access that I need to export to a text file. This data has 4
or more decimal places and when I export the data the text file ends up with
rounded data to the first decimal place. Please help

Thanks,
Craig

 

[Ken Snell \(MVP\)]

Use a query as the source of the data to be exported. In the query, replace
the field in question with a calculated field that uses the Format function
to give you the desired number of decimal places (in this example, 7
places):

Format([FieldName], "0.0000000")