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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I do for repeat '0' in one SELECT TABLE 2
Access Macro Repeat Expression using value of a field in table 0
How to export table from outlook into ms access table? 0
Access Access - Is it possible to repeat fields in a form? 1
value displayed repeatedly 9
Random non-repeating queries MS Access 1
vlookup in access ? query 2
Adding HTML into the Web browser control 1

Back
Top