Is there a function to do this....

[Nowherefast]

Hi,



Is there a function to do the following....

I have a table with approx. 900,000 records.
One of the columns(text) has values such as.....

4589
3211
12
999345

877

I would like to fill the column with 9 bytes preceeded with zeros...
so the above examples will output as:

000004589
000003211
000000012
000999345
000000000
000000877

Hope this makes sense....thanks in advance

[gman]

The easiest way is ake your table and copy it to excel the format the column with the custom feature fill the custom feature in with 9 zeros and then all the entries will have preceeding zeros, Then import the list back to access with the new item numbers

[Ahmed Elalfy]

Dear Nowherefast,

The easiest way to do that in the following steps:
open table design view
select the mentioned field
in field properties write in format 000000000
save the table and open it.

Kindly try and feedback.

Ahmed