Quick summary
A Union Query in Microsoft Access combines rows from two or more tables or queries into a single result set. This tutorial walks you through opening Query Design, selecting the Union query type, writing the SQL, and running it to view merged results.
Steps
- Go to the Create tab in the Microsoft Access ribbon.
- Select Query Design to open a new query in design view.
- In the Query Type section, select Union to switch to Union query mode.
- Write the Union query SQL combining the fields and tables you want to merge.
- Click Run to execute the query and view the combined results.
