Update Query - Delete Part of a Field

[bwalk037]

Hello,

I have a table with an account number field. It has about 400,000 account numbers. The problem I have is every account number has two zeros infront of the account number. For example, 00712394. Is there away to do a update query to delete the two zeros from the front of the account numbers?

Thank you

 

[pbaldy]

If they're all numeric like that, you could probably use CLng(). You could also use Mid().

 

[bwalk037]

Thank you. The Mid() expression was exactly what I was looking for.