adding two tables

[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)?

 

[Golfinray]

Yes. Use a union query. In sql view of queries type
select *
from [yourfirsttable]
union all select *
from [yoursecondtable];

 

[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...

 

[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.