SQL•SQL References

MS Access Concat With &

Example

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	Description
string1, string2, string_n	Required. The strings to add together

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

SELECT Address & ", " & PostalCode & ", " & City AS Address
FROM Customers;

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

Syntax

string1
 &
string2
 &
string_n

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

Works in:	From Access 2000