Removing digits from column in table 1

[DJonesatAC]

We have approximately 10,000 records in an Access table. In the first column, five zeros were added before the 9 digit identification number that we use. Rather than going through each record and manually removing these zeros, is there a way to have them removed from the record? For example:
00000111111111
00000222222222
00000333333333

I would like to have the column only list the 9 digit identication number and automatically remove the 5 zeros, all of which are the five 5 digits left to right. Any suggestions?

 

[GHolden]

If you do an update query.
Add the table you want to change
Add the field you want to change

in the 'update to' type

Right([tblName]![fldName],9)

this will update all fields (fldName) in table (tblName)to only the right hand 9 digits

I would test this on a copy before using on the real thing!!

 

[mikey69]

The "Right" function will also do this.