how can i export an amount ie 4055 as 00000004055

  • Thread starter Andrew Gamvbini
  • Start date
A

Andrew Gamvbini

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

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
 
Top