Exporting wizard truncates value

[Eric D]

I have a numeric field that needs to be formatted as six
decimal places long. I have tried defining the field size
to both single and double. However, when I export the
table (tab delimited text file) using the export wizard,
the fields are truncated to two decimal places. How can I
get the data export to export to six decimal places?

 

[John Nurick]

Hi Eric,

Create a query that uses calculated fields to format the numbers the way
you want, e.g.
fMyField: Format([MyField], "0.000000")
Then export the query.

 

[Eric]

This works, however, the export from the querry has a
bunch of junk in it I do not need. I need a tab delimited
file with no column headers.

-----Original Message-----
Hi Eric,

Create a query that uses calculated fields to format the numbers the way
you want, e.g.
fMyField: Format([MyField], "0.000000")
Then export the query.

I have a numeric field that needs to be formatted as six
decimal places long. I have tried defining the field size
to both single and double. However, when I export the
table (tab delimited text file) using the export wizard,
the fields are truncated to two decimal places. How can I
get the data export to export to six decimal places?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.