Export Precision

[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

 

[John Nurick]

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.

 

[Guest]

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.