New column combining string and double

Question

Hi we are trying to create a new field what will output a combination of text & the value in a numeric field.

Example:

New field:

"Record ID -" + [Record ID#]

you would see  Record ID - 12345

The only way we can figure out to do this (and not receive a data type error), is to change the [Record ID#] data to string to have this work.

We do not want to change the data type and then change it back.

Is there not an easier way?

MSalvage · Accepted Answer

@nogap2,

I think you are looking for the ToString Function in the formula tool. Something like:

New field:

"Record ID - " + ToString([Record ID#], 0)

Best,

MSalvage

Dynamomo · Accepted Answer

You need to turn the number into a string if you are going to concatenate it with a string but you can do this on the fly.  Use the ToString() function

"RecordID -"+tostring([Record ID#]