Export Data to Text file - Truncation of numeric data

[JM]

I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!

 

[John Nurick]

Hi JM,

Create a query on your table and export that. In the query, use a
calculated field with the Format() function to format the number the way
you like, e.g.:

fNumberField: Format([NumberField], "#,##0.000")

I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Richard Choate]

Did you post this same problem a few days ago?


I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!

 

[JM]

I'll give it a try.
Thanks for your help.

-----Original Message-----
Hi JM,

Create a query on your table and export that. In the query, use a
calculated field with the Format() function to format the number the way
you like, e.g.:

fNumberField: Format([NumberField], "#,##0.000")

I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.