Leading Zero's

[Guest]

I have an access database with a field called matter code that contains 5
digit numbers (text type). We have recently changed our time & billing
system to use 6 digit numbers. I changed the field size to 6, but I need to
now add a leading 0 to all existing 5 digit numbers. How can I accomplish
this? Thanks

 

[fredg]

I have an access database with a field called matter code that contains 5
digit numbers (text type). We have recently changed our time & billing
system to use 6 digit numbers. I changed the field size to 6, but I need to
now add a leading 0 to all existing 5 digit numbers. How can I accomplish
this? Thanks

Run an update query:

Update YourTable Set YourTable.[FieldName] =
Format([FieldName],"000000")