Truncating decimals on txt export

[Ray Joslyn]

How can I get more than 2 decimal places to be exported when exporting to a
fixed length txt file?
Thanks

--
Ray Joslyn
ETG Inc.

To reply via email remove NOSPAM
and replace with rjoslyn

 

[Ray Joslyn]

I changed the fields to text and then exported it, then it worked.
Ray

 

[John Nurick]

Hi Ray,

Create a query that uses the Format() function in calculated fields,
e.g.
fMyNumber: Format([MyNumber], "0.0000")
and export the query.