Leading Zeros

[Guest]

I have a list of numbers in a table column:
456
12
4568
111111
What I need is to have the numbers all 9 digits like:
000000456
000000012
000004568
000111111
I just don't remember how I updated the field in one step. I know someone
must have the answer.
Thanks.

 

[tina]

if you just want to "show" 9 digits, format the field as 000000000.
if you want to "change" the values to include the leading digits, the field
must be a text field, not numeric. to update all the values in a text field
at once, try an Update query on a *copy* of your table, using the following

Right("000000000" & [TableName].[FieldName], 9)

hth

 

[Pascal Constant]

Just use "format" as follow:

Format([yourfieldname],"000000000")

--
Byeke,
Pascal cé


"Adding Leading Zeros" <Adding Leading (e-mail address removed)>
wrote in message
news:[email protected]...