So here are the instructions from MS on one of their pages
Combine the select queries in SQL view
On the Create tab, in the Queries group, click Query Design.
A new query opens in Design view.
Close the Show Table dialog box.
On the Design tab, in the Query group, click Union.
Nice, only...