ADVERTISEMENT

Access: Concatenate strings together

---

To concatenate multiple strings into a single string in Access, you need to use the "&" operator to separate the string values.

string_1 &  string_2 &  string_n

For example:

"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"

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"

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.