Combine Tables Then Append

I want to combine 3 tables with like data then append it with a filter.

Tables: NewStarts, Complaints, Memos

Combine: Date, Address, Route, Pub, etc....

Then sort: previous 8 days, pub/freq for that day etc...

I can already do the append filter, but I cant combine and then append.
I tried a Union and did the combine.. but lack the part to append the union.

Please help me :)

re: Combine Tables Then Append

To make this easier, do the UNION query and save it.
Now build an APPEND query using the UNION query as its source.

You can also do it with embedded subqueries.

re: Combine Tables Then Append

I tired that. I get multiple records depending on the total amount of entries in a table. IE: table 1 has 9 lines therefore the appended union results 9 duplicate entries.