In the SQL query, provides the horizontal merge and the vertical merge two tables above, explained below to explain to you:
One, horizontal merge multiple tables, the premise is that more than one table to be able to relate to the field, directly with the interactive query can be.
Second, vertical merging requires more than one table field name, Number of fields, field order, attributes exactly the same can be performed, after this premise, the SQL query statement is as follows:
SELECT Table 1.*
from table 1;
UNION SELECT Table 2.*
from table 2;
UNION SELECT Table 3.*
From table 3
...
UNION SELECT Table n.*
from table N;
In the Access query design state, click the right mouse button to select the SQL view, copy the above statements and then paste, the name of the table to your own table name on the line.
(Turn from Baidu know) https://zhidao.baidu.com/question/467882578.html
Make different table stitching on access