Re: Export to Fixed Width File

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 09:07:09 -0500

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" <noidea@nospam.com> wrote in message
news:ehSL5OF3EHA.3132@TK2MSFTNGP14.phx.gbl...
> 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
>
>

Relevant Pages