Export from Access to Text file: Specified number of decimal place

H

HelloKitty

Hi,

How could it be set up to export from Access to Text file with desired
number of decimal places, say 6 decimals? Can Access 2000 do this?

It seems Access usually retains 2 decimals in exporting to text files.

Thanks a lot for your help in advance!

Sincerely,
 
V

Van T. Dinh

You can create a Calculated Field in a Query like:

MyFormattedNumber: Format([NumberField], "0.000000")

+ other Fields as required and then use the Query as the DataSource for your
export.
 
Top