Export to comma-delimited truncates numbers after decimal

[Geoff]

How can I keep my crosstab query from truncating numbers after the decimal
point when exporting to comma delimited text file in Access 2000/2002 eg:
"67050OC",139.,6. it works fine when exporting to excel but truncates in
both fixed width and comma delimited

 

[Guest]

Hi Geoff,

I just tried several export experiments, using the "Quarterly Orders by
Product" crosstab query in the sample Northwind database. I was able to
export the results without any truncation in the decimal values, for both
fixed width and comma delimited format. I did not place a check in the "Save
Formatted" option on the first screen of the export wizard.

You might try using the format function to force a fixed number of decimal
places. In the above query, you could use this, for example, to get five
decimal places:

ProductAmount: Format(Sum(([Order
Details].[UnitPrice]*[Quantity]*(1-[Discount]))),"0.00000")

Note: Everything is on one line in the Field row of the QBE (Query by
Example) grid.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________