I have two fields that I need to concatenate together but I need to add zeros so one said has 4 digits and the other side has 2 digits. Both separated with a hypen. For Example, 0024-14.
This is the code I have written am I close???
Left([ACONTROL], 4, "-") & Right([ASECTION], 2)
So, it would be field ACONTROL with 4 digits and ASECTION with 2 digits.