Here's how to create a UNION query in MS Access:
- Go to the 'Create' tab.
- Select 'Query Design'.
- Select 'Union' found in the 'Query Type' section.
- Write the union query.
- Click 'Run' to view the results.
Here's how to create a UNION query in MS Access: