I am trying to write an update query that will convert all of my records in a field to 14 digits with leading zeros (0).
So, instead of
I would like
In Excel, I do it using =Rept("0",14-Len(B1))& B1, but cannot figure out the syntax in Access.
This must be simple, but I am tearing my hair out. Please help. Thanks.