TransferText Action exports only 2 decimal places 1

[drewmayerson]

I run a macro to export the results of a query to a text file using the TransferText Action in a macro. Even though the numbers in my table and subsequent query have 4 to 6 places to the right of the decimal point, the results of my TransferText Action clips it to 2. Any ideas?

Thanks, Drew

 

[PaulF]

Not sure why it happens, probably uses the Windows Default. Try formatting the output in your query

Format([FieldName],"#,###.######&quot

PaulF

 

[drewmayerson]

Paul,
Thanks. You were right about it being a Windows quirk. I finally had to go to Regional Settings > Numbers > Decimals and set the default to 6. Worked like a charm. Who knew?

Thanks again,
Drew