I'm importing data into Access and I need to make each account number 8 characters long. How do I add 4 zeros to the begining of those accounts with only 4 digits? Add 3 zeros to the begining of those accounts with only 5 digits, etc.
Essentially, I need to equivelant of the 'REPT' function in Excel.
Thanks in advance.
Essentially, I need to equivelant of the 'REPT' function in Excel.
Thanks in advance.