Concatenate Operator &

The concatenate operator & returns a text value created by joining its left-hand and right-hand operands.

Remarks

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

If either operand is null, the result is null. Consider wrapping text column values with the Nz function. Alternatively, use the List function to concatenate values while ignoring null values.

Examples

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