I want to concatenate two number fields with leading zeros.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields containing numbers such as 1661 and 5. I want to
concatenate them so the they appear like this...16610005. The first number
will be six digits with no leading zeros the second will be four digits
including leading zeros.
 
Back
Top