Trouble with TransferText Output

[sroche]

I am having trouble with the Transfer Text Output of a query. The output contains decimal points the I would like to remove. Any help would be greatly appreciated.

Thanks.


Function ExportCops()
DoCmd.TransferText acExportDelim, , _
"Cops Interview Negive by Store Query", "D:\My Documents\Test.csv"
End Function


File:
2.00,2004.00,12.00,1
20.00,2004.00,12.00,1
68.00,2004.00,12.00,2
74.00,2004.00,12.00,1

 

[LNBruno]

Have you tried changing the underlying query to format the values?

< M!ke >