exporting to text need decimals

  • Thread starter Thread starter wpppat
  • Start date Start date
W

wpppat

When exporting a table to text the decimals are only 2 positions. How do I
get 4 decimal positions?
 
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;
 
Back
Top