lfpm062010's suggestion is what I'd suggest to, just be aware that you won't get a 'design view' for a union query. To put a union query together build the layout you want first, then, assuming all the fields for both sets of data are identical, start building on your original query.
i.e. Let's assume your tables are table1 and table2
Get one portion of your query working first:
Code:
SELECT Event, EventDate FROM Table1
then start adding additional data
Code:
SELECT Event, EventDate FROM Table1
UNION ALL
SELECT Event, EventDate FROM Table2
When I build union queries I always keep a copy of the 'base' query so that I can cut and paste the SQL into the union query if I modify it, and only modify a table name to make it work again.