Combine the results of several select queries by using a union query

To combine the results of two or more select queries into one result set, you can use ... In Microsoft Office Access 2007, you use the SQL View object tab to write ...

support.office.com