HOW I DO FOR REPEAT '0' IN ONE SELECT TABLE.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

FOR Example: I have one number 8955 and it would like to visualize '000008955'

This is in the MS-ACCESS

THANKS
 
There is not much info in your question, so I cant' be too specific. It
appears you want to pad you number with leading zeros so that the resulting
string is 9 characters long.
Here is a simple formula to do that:

x = 8955
String(9-Len(x),"0") & x
The result is 000008955
 
If it is a text field then use this --
Right("0000000000" & [YourNumberField], 9)

If it is a number field then use this --
Format([YourNumberField], "000000000")
 
Back
Top