Concatenate operator &

The concatenate operator & returns a text value that is the concatenation of its left-hand and right-hand operands.

Remarks

If an operand is not a text value, the function ToText is automatically used to convert it to text before concatenating.

If one operand is null, the result will be null.

Examples

• [Salutation] & " " & [Last Name] concatenates the values in the Salutation and Last Name columns with a space in between them.
• "Mr." & " " & "Smith" returns "Mr. Smith".
• "Conference" & "2014" returns "Conference2014".