Exporting Number with Decimals to Text Rounds to 1 decimal place

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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