How to Merge Two Fields in MS Access
- George Apostolov
- 05 Sep 2025
Guide
Go to the 'Create' tab.
Click 'Query Design'.
Select the table containing the fields you want to merge.
Click 'Add Selected Tables'.
In the query design grid, click an empty column.
Enter an expression to merge the fields.
Click 'Run' in the Ribbon.
The query results will display a new column with the merged field.
Create your first interactive demo in minutes
No credit card required • Start building today