The CONCAT() function allows you to easily join two string values.
CONCAT(<field or string 1>, <field or string 2>)
Example: combine first and last name for a mailing list
CONCAT([Individual].[FirstName],[Individual].[LastName])
Return to home