Exporting wizard truncates value

  • Thread starter Thread starter Eric D
  • Start date Start date
E

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?
 
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.
 
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?
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top