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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HelloKitty - 27 Nov 2006 16:50 GMT

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,

Reply to this Message

Van T. Dinh - 28 Nov 2006 13:21 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

> Hi,
>
[quoted text clipped - 6 lines]
>
> Sincerely,

Reply to this Message