Exporting Number with Decimals to Text Rounds to 1 decimal place

C

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
 
K

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top