Guide

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.