Appending Three Tables

[Jonny]

I have three tables with a same structure (fields and e.t.c). I wanna append them into one table.
How I do it?

 

[Rickster57]

Append

If you truly have 3 tables with identical fields I think you have answered your own question? Take table2 and write an append query to append it to table1. Then another append query to append table3 to table1.

 

[Bat17]

If this is a one-off I would not even bother with the append just open the table, highlight all the records and copy and paste!

Peter