B
BorisS
in '07, I have two tables, with the exact same structure. Can I add them
together to create one new table (or add one to the other)?
together to create one new table (or add one to the other)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Golfinray
Yes. Use a union query. In sql view of queries type
select *
from [yourfirsttable]
union all select *
from [yoursecondtable];
select *
from [yourfirsttable]
union all select *
from [yoursecondtable];
N
NetworkTrade
you can create an AppendQuery to append all the data of one to the other....
if you plan to abandon one of the tables - you will need to remember to
modify all queries/forms/reports that have been sourced on it - so that they
are sourced on the remaining table...
if you plan to abandon one of the tables - you will need to remember to
modify all queries/forms/reports that have been sourced on it - so that they
are sourced on the remaining table...
J
John W. Vinson
in '07, I have two tables, with the exact same structure. Can I add them
together to create one new table (or add one to the other)?
You can (temporarily) combine the data from the two tables into one larger
recordset using a UNION query, or you can permanently add the records in one
table into the other table using an APPEND query. See the online help for
Union and Append for examples.