MS Access Concat With &
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 |
---|