I want to generate a "project identifier" in a text field based on several fields of information on the current record.
I'm using "Insert Calculated Result"
Year of (DateReported) District is a 3 Character text, Facility is two character text, then the actual record number.
Year ( Projects::Date_Reported ) + "-" + Projects::District + "-" + Projects::Facility + "-" + Projects::Projects_PK.
Perhaps I'm expecting too much but the only thing that loads in the target field is numbers. The dashes and the text do not. The target field is text. I'm stumped.