leading zeros & trailing zeros

[Guest]

I am trying to export a table to create a file. I am trying to export a
fixed field length of 15 positions for a dollar amount. The field must have
leading zeros and if the amount ends with a zero (example 12.50) it must
contain the trailing zero(s). How to I accomplish this???

Field is: 12.50
I need: 000000000001250

 

[Guest]

Use the Format Function:

= Format(SomeVariable * 100, "000000000000000"

The multiplication by 100 is necessary to avoid losing the cents altogether.

 

[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