# How to Merge Two Fields in MS Access

> To merge two fields in MS Access, go to the Create tab, click Query Design, select and add the table containing the fields, click an empty column in the grid, enter an expression, and click Run in the Ribbon to display the new merged column in the query results.

Canonical: https://livedemo.ai/tutorials/how-to-merge-two-fields-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a49dcab56e05a00ff4d80/preview?step=1

## Steps

1. Go to the 'Create' tab.
2. Click 'Query Design'.
3. Select the table containing the fields you want to merge.
4. Click 'Add Selected Tables'.
5. In the query design grid, click an empty column.
6. Enter an expression to merge the fields.
7. Click 'Run' in the Ribbon.
8. The query results will display a new column with the merged field.