AnsweredAssumed Answered

Adding zeros or numbers in a Field

Question asked by MLCouden on Oct 24, 2014
Latest reply on Oct 27, 2014 by Dan_Patterson

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.