Decimal places for numbers exported in ImportExportText

[accessfever]

Hi I have a macro to export a query to CSV format by "ImportExportText". My original number field in the query have 4 decimal places. After the export, I see the numbers are in 2 decimal places in CSV file. Is it a way to change the query or some settings to show 4 decimal places in the output CSV file? Any help will be appreciated.

 

[boblarson]

Set the query to have those decimal places. Create a substitute field in your query like this:

NewFieldNameHere:Format([OriginalFieldNameHere], "#.0000")