THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Concat With &

❮ MS Access Functions

Example

Add 3 columns together into one "Address" column:

SELECT Address & ", " & PostalCode & ", " & City AS Address
FROM Customers;
Try it Yourself »

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

❮ MS Access Functions