How do I export an amount field into a fixed field w/o formatting

[Guest]

It keeps left justifying, leaving off the sign and not 0 filling. I need to
send the file to a mainframe for processing and am using either the export or
TransferText processes.

 

[Jeff Boyce]

Create a query that returns the values. Use the Format() function to get it
looking like you want. Then use something like CStr() to convert it to a
string representation. If I recall, that way when you export it keeps the
formatting.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Roger Carlson]

IIRC, the Format() function converts numbers to text, so the CStr()
shouldn't be neccessary.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportFormattedFixed.MDB" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L