exporting to text need decimals

exporting to text need decimals

Post by d3BwcGF » Sat, 21 Mar 2009 09:37:08


When exporting a table to text the decimals are only 2 positions. How do I
get 4 decimal positions?
 
 
 

exporting to text need decimals

Post by Ken Snell » Sun, 22 Mar 2009 03:02:44

You'll need to create and save a query based on the table, and export the
query. In the query, in the place of the actual field, use a calculated
field that formats the number as a 'string' with 4 decimal places:

SELECT Field1, Field2, Field3,
Format(Field4, "0.0000") AS Field4,
Field5, Field6
FROM YourTableName;

--

Ken Snell
<MS ACCESS MVP>
http://www.yqcomputer.com/