Export Precision

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

When I export fractional data to a comma delimited file
the data is exported in a fixed format of two decimal
places. The actual data precision is much higher in the
database. How can I get the exported data to be in the
same precision as the database? Thanks for your help.

Mark
 
Hi Mark,

Create a query that uses the Format() function in calculated fields,
e.g.
fMyField: Format([MyField], "0.0000000000")
Then export this query to the CSV file.
 
Thanks for your help.

Mark
-----Original Message-----
Hi Mark,

Create a query that uses the Format() function in calculated fields,
e.g.
fMyField: Format([MyField], "0.0000000000")
Then export this query to the CSV file.

When I export fractional data to a comma delimited file
the data is exported in a fixed format of two decimal
places. The actual data precision is much higher in the
database. How can I get the exported data to be in the
same precision as the database? Thanks for your help.

Mark
Click to expand...

--
John Nurick [Microsoft Access MVP]

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