C CS Apr 8, 2010 #1 How do I add leading zeros to this? BLDG: Mid([LOCATION],InStr([LOCATION],"-")+1) Please help.
K KARL DEWEY Apr 9, 2010 #2 My response yesterday -- Left([YourField], InStr([YourField], "-")-1) & Right("00000" & Mid([YourField], InStr([YourField], "-")+1, 5)
My response yesterday -- Left([YourField], InStr([YourField], "-")-1) & Right("00000" & Mid([YourField], InStr([YourField], "-")+1, 5)