Leading Zero's

D

Delores Elias

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
 
F

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
Click to expand...

Run an update query:

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