merging column name and value in one record

[wilkob]

I don't know if this is possible, but I thought I ask

I have a column with name Diameter
in the records of the column I have the different dimensions in numbers 1,2,3 etc

Is there a way to create a new value in another field that gives

Diameter: 1 mm
Diameter: 2 mm
Diameter: 3 mm

Just wondering

 

[boblarson]

If your column is named Diameter then you can't use that name for the new column. So you could use:

ItemDiameter:[YourNumberFieldNameHere] & " mm"

Or

Diameter1:[YourNumberFieldNameHere] & " mm"