I need to update a column in access where I should be removing the 7 leading characters in a field.Example:
Column value before: AB34567213. Colum value after: 213
So, I tried using VB in Access and this is what I got so far:
Private Sub delete_leading_chars()
Update table_name
Set col_name = Right(col_name, Len(col_name) - 7)
End Sub
Is there a way to insert this module just like excel where you insert functions in a field to update it/do a calculation on it? In other words, where do I put it in order to run it? If that’s not possible, how should I go about updating that field given the above module? Any idea that will steer me in the right direction is much appreciated!!