Update Reference Numbers

[HelsBels]

Hello

I have 18,000 unique reference numbers in a table that I need to amend. The ref nums are all 16 digits in length and they all start 8243161.... then the rest of the 9 digits are all unique. However, the number 161 needs to be amended to 141. The rest of the number all needs to stay the same.

What function would I use to update each of the 18000 numbers, it is only the 6th digit that needs replacing, from a 6 to a 4?

 

[dcx693]

You can use an update query with an "update to" expression like this: "8243141" & Mid([ref_num_field],8)

 

[HelsBels]

Thanks that's worked a treat!