Combine Two Text Columns in a Microsoft Access Query
Question details
Combine two text fields into one calculated column in a Microsoft Access query.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user wants to join text from two columns, such as a customer's first and last names, in a query result.
- Observed behavior
- The query should return the combined text under a custom column name.
Identify the table and field names you want to combine. Replace the example names with the names in your Access database.
Combine fields in Access Query Designer
Use a calculated field to join two columns without writing a complete SQL statement.
In Access, select Create > Query Design and add the table containing the fields, such as Customer.
In the Field row of an empty query grid column, enter: Customer Name: [FirstName] & " " & [LastName]. The quoted space separates the two values.
Select Run on the ribbon to display the combined values in the Customer Name column.
Combine fields in Access SQL view
Use an SQL SELECT statement when you prefer to edit the query directly.
Work with combined text in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats. Move spreadsheet data into WPS Spreadsheets for everyday editing; Access queries still require Microsoft Access.

Frequently Asked Questions
Does Microsoft Access support the CONCAT function?
Access queries use the ampersand operator to join text. For example, enter [FirstName] & " " & [LastName] in a query expression.
How do I add a space between the two fields?
Place a quoted space between ampersands, as in [FirstName] & " " & [LastName]. Use another quoted separator, such as ", ", if needed.
How do I name the combined column?
In Query Designer, put the name and a colon before the expression, such as Customer Name: [FirstName] & " " & [LastName]. In SQL view, use AS [Customer Name] after the expression.
Can I combine fields from a named table?
Yes. Qualify each field with its table name, such as [Customer].[FirstName] & " " & [Customer].[LastName], in the query expression.




