Combining 2 numeric Fields

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
I have 2 nummeric fields, one is Contract Number the other is Plan Number. How can I combine these 2 existing fields into 1 new field, example Contract Number is 123456 , Plan Number is 001. I need a 3rd field to combine the first two into a Contract/Plan number field of 123456001
Photo of David Grodzicki

David Grodzicki

  • 72 Points

Posted 2 years ago

  • 0
  • 1
Try this

ToText([Contract Number] & [Pan Number]

If your Plan number reads like in your post, then it is not a numeric field. It is a text fmessage field.
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Small syntax correction:

ToText([Contract Number]) & [Plan Number]

Also, if you want to make sure they both can accept the text number:
ToText([Contract Number]) & ToText([Plan Number])

If you want to add a hyphen in between, or any character
ToText([Contract Number]) &" - "& ToText([Plan Number])
Thx for the syntax correction.  I was on my iPad during breakfast :)
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
I know how that goes.  My phone loves to mess up my brackets.  Feel free to correct me anytime.  It for the users anyway.  You and I both know this stuff like the back of our hand.  And Dan D is on another level.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Level Up!