Trying to change data in a field to a fixed number of characters. If an ID is less than 8 characters, then 0's need to be added to arrive at 8 characters.
ID: ABC123, DEF45, 78
Desired ID: 00ABC123, 000DEF45, 00000078
This needs to be a calculated field.
Thank you in advance for any help!
Sam & Eliza
Try RIGHT('00000000' + [IdField],8)