MS Access: Concatenate strings together
In Microsoft Access, you can concatenate multiple strings together into a single string.
Concatenation Function (Syntax)
The syntax to concatenate strings using the "&" operator is:
string_1 & string_2 & string_n
The Concatenation function can be used in the following versions of Microsoft Access:
- Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
|"new" & "ark"||would return "newark"|
|"Tech on the" & " Net!"||would return "Tech on the Net!"|
|"This " & "is " & "a test"||would return "This is a test"|
Concatenation Examples (in VBA Code)
The "&" operator can be used to concatenate strings in VBA code. For example:
Dim LSQL as string LSQL = "Select * from Suppliers" LSQL = LSQL & " where Supplier_ID = 2345"
Concatenation Examples (in SQL/Queries)
You can use the "&" operator in a query to concatenate multiple fields into a single field in your result set.
To do this, open your query in design mode. Enter your field names in the query window separated by the "&" symbol.