How to Create a UNION Query Using SQL in Microsoft Access

Using Microsoft Access SQL, you can easily combine the results of two or more queries. Here’s how you do it.

Difficulty: Moderately Easy

Instructions

1. Open the SQL view window.

2. Type a SELECT query. For example: SELECT companyName, sales FROM companyList2005. Press Enter.

3. Type "UNION" and press Enter.

4. Type another SELECT query. For example: SELECT companyName, sales FROM companyList2006.

5. Run the query.

Tips & Warnings

• In order to be combined, the results from the SELECT queries must contain the same number of columns.