Exporting data to external text file

[Pat Miller]

When I export a numeric field for example 8.275 to a
external txt file the resulting field in the txt file
shows only 8.27 . The field is defined as having 3
decimal positions. Why does it drop or truncate the third
decimal position.

 

[John Nurick]

Hi Pat,

That's the way Access does it; the reason is buried in the mists of
time. You can get round it by using a calculated field in a query, e.g.
fMyField: Format([MyField], "0.000")
and then exporting the query.