MS Access Concat With &

Posted by

MS Access

Concat With &

Example

Add 3 columns together into one “Address” column:

SELECT Address & “, ” & PostalCode & “, ” & City AS Address
FROM Customers;


Definition and Usage

The & operator allows you to add two or more strings together.

Syntax


string1

&

string2

&

string_n

Parameter Values

Parameter Description

string1, string2, string_n
Required. The strings to add together

Technical Details

Works in: From Access 2000