Others

Combine Two Text Columns in a Microsoft Access Query

Steven ParkerSteven Parker Nov 22, 2026 868 views

Question details

Combine two text fields into one calculated column in a Microsoft Access query.

Combine Two Text Columns 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.
Before you start

Identify the table and field names you want to combine. Replace the example names with the names in your Access database.

Solution 1Recommended

Combine fields in Access Query Designer

Use a calculated field to join two columns without writing a complete SQL statement.

1
Open Query Design

In Access, select Create > Query Design and add the table containing the fields, such as Customer.

2
Enter the expression

In the Field row of an empty query grid column, enter: Customer Name: [FirstName] & " " & [LastName]. The quoted space separates the two values.

3
Run the query

Select Run on the ribbon to display the combined values in the Customer Name column.

Join without a separator: To place the values directly next to each other, remove & " " from the expression.
Free Microsoft Office alternative

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.

Combine text values in spreadsheet cells using formulas.Open and edit Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface for everyday data tasks.Move compatible Office documents into a lightweight suite.
microsoft office alternative - wps office

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.