| | |
|
|
|
Exports and decimals |
|---|
| message from Ben Jammin on 3 Jun 2004 |
Anyone know how to export a table to a text file and get
more than 2 decimals?
|
| Ken Snell replied to Ben Jammin on 4 Jun 2004 |
Set up an export specification that specifies the decimal format for the
field and then use that export spec in a macro (TransferText) or VBA code
(DoCmd.TransferText).
You set up your spec by starting to do the export manually, and when the
wizard window opens, click on the Advanced button at bottom left -- you then
can set all the export specification parameters and save the spec as
whatever name you want. Then cancel the export and use the spec name in one
of the above methods.
|
| Ben Jammin replied to Ken Snell on 3 Jun 2004 |
Thanks for the help.
I tried what you said but don't see any way to change the
decimals in the Advanced screen.
format for the
(TransferText) or VBA code
manually, and when the
bottom left -- you then
the spec as
the spec name in one
|
| Ken Snell replied to Ben Jammin on 4 Jun 2004 |
My oversight....that's what I get for doing things from memory!
Replace the field in your query with a calculated field that formats the
OutputField: Format([FieldName], "0.0000")
|
|
Archived message: Exports and decimals (Microsoft Access Forms)
