MS Access Concat With &

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.

string1 & string2 & string_n

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

Works in:	From Access 2000