how can i export an amount ie 4055 as 00000004055

[Guest]

i need to out put/export amounts as a string of 11 digits

ie 4055 as 00000004055
or 11660 as 00000011660

Any help is greatly appreciated....

 

[M.L. Sco Scofield]

Try:

Format([YourFieldName], String(11, "0"))

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Roger Carlson]

Use the format function: Format([TheField], "00000000000").

On my website () there is a small Access sample database called
"ExportFormatted.mdb" that illustrates how to do this.

--
--Roger Carlson
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