MS Access Concat With &

❮ Previous ❮ MS Access Functions Next ❯

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

❮ Previous ❮ MS Access Functions Next ❯
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.