Hi There,
I'm having difficulty exporting a query to a CSV file and retaining the numbers after the decimal points.
Well it's more like it does'nt retain the 3rd number after the decimal point.
Eg.
1258.016 -> 1258.01
Anyone have any idea why?
The query iteslf shows this number but the exported data to csv does not.
I'm having difficulty exporting a query to a CSV file and retaining the numbers after the decimal points.
Code:
DoCmd.TransferText(acExportDelim, , "qry_ExportToCSV, OFFTRN.csv", False)Well it's more like it does'nt retain the 3rd number after the decimal point.
Eg.
1258.016 -> 1258.01
Anyone have any idea why?
The query iteslf shows this number but the exported data to csv does not.
