Specify number of decimal points in an export 1

[nickperez22]

I am exporting a table that has a cost field with 3 decimal points to a text file. The table exports fine except that the cost are ouputted with only 2 decimal points.

I reviewed the export wizard several times and didn't see any place where I could specify the number of decimal points.

 

[dhookom]

Export from a query that has a calculated column like:
Field3Dec:Format([NumField],"0.000")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.