Export to Fixed Width File

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Access XP

I have a table that I wish to export to a fixed width text file - no problem
.. . . however I have one field that can have a value with up to 5 decimal
places. For some reason the export routine creates a text file with the
following:

9.8e-03

I have tried changing the table field to text and that hasn't made any
difference.

How can I get around this problem or what am I doing wrong?

Thanks

A
 
Export a query that is based on that table (don't export the table
directly). In place of the field that is to have 5 decimal places, use a
calculated field that formats the number the way you wish:

MyNum: Format([FieldName], "0.00000")
 
Thanks
Ken Snell said:
Export a query that is based on that table (don't export the table
directly). In place of the field that is to have 5 decimal places, use a
calculated field that formats the number the way you wish:

MyNum: Format([FieldName], "0.00000")


--

Ken Snell
<MS ACCESS MVP>

Newbie said:
Access XP

I have a table that I wish to export to a fixed width text file - no problem
. . . however I have one field that can have a value with up to 5 decimal
places. For some reason the export routine creates a text file with the
following:

9.8e-03

I have tried changing the table field to text and that hasn't made any
difference.

How can I get around this problem or what am I doing wrong?

Thanks

A
Click to expand...
Click to expand...
 
Back
Top