exporting to text need decimals

[wpppat]

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

 

[Ken Snell MVP]

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;