Adding two tables of the same structure one after the other.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 tables that I would like to join together. All of them have the same
fileds.
I would like to simply add the tables one below the other. Is there a
simple way of doing that?
 
Where? In a report?

If you have four tales with the exact same structure, then you should
probably combine them into one table and add a field to indicate which table
they came from. If each table is from a different department, for example,
then add a department field to your records.

Once you add the type field to each table and update it (using an update
query), you should then create an append query to add the records from one
table to the other. Once your main table has all the records, delete the
three extra tables.

Before you do anything, do at least one backup!!
 
I have 4 tables that I would like to join together. All of them have the same
fileds.
I would like to simply add the tables one below the other. Is there a
simple way of doing that?
Click to expand...

If you want to do so permanently (which might be a good idea;
identical tables suggest a flawed data model), you can use three
Append queries to append three of the tables into the fourth.

If you want to keep the tables separate and just combine them for a
report or the like, use a UNION query. See UNION in the Help - it's
got a pretty good explanation.

John W. Vinson[MVP]
 
Back
Top