How to Merge Two Fields in MS Access

Quick summary

This tutorial shows how to merge two fields in Microsoft Access using a calculated column in Query Design. By writing a concatenation expression in the query grid, users can combine separate fields into a single output column without altering the original table structure.

Steps

1. Go to the Create tab in the MS Access ribbon.
2. Click Query Design to open the query builder.
3. Select the table containing the fields you want to merge.
4. Click Add Selected Tables to add it to the query design view.
5. In the query design grid, click an empty column to place your cursor.
6. Enter a concatenation expression to merge the fields into one combined value.
7. Click Run in the Ribbon to execute the query.
8. Review the query results, which will display a new column with the merged field.