In Access 2007 I need to combine multiple tables into 1 having identical fields

[djbbenn]

Hello,

I am working with Access 2007. I am fairly new with it.
I need to combine multiple tables into 1 having identical fields into a single table.

Is there any simple & easy way to do so?

[Jason Bourne]

You use an Append query. Make a structure only copy of one of the tables (use Copy and paste).
Then add the identifier.
Now run Append queries for each table into the new main table.

[MindSpace]

• Make a new empty table or choose the existing table to be the central repository of the data.
• Make a query for all field and records for the first table. Change the query type to Append and select the destination table as the target.
• Execute the query
• Delete the source table and replace with the next
• Repeat the procedure until all source tables have been used.

[Yusuf Khan]

Hi
You need to establish a relationship between the tables. This is really simple in Ms access. You can drag and drop fields from one table to the other to create the relationship.

SELECT TableA.PrjectNumber, TableA.DVD#, tableb.BobNumber
FROM tableA INNER JOIN tableB ON TableA.ProjectNumber = TableB.ProjectNumber;

http://office.microsoft.com/en-us/ac...963201033.aspx

[warwilf]

You can also do a UNION select. SELECT * FROM TABLE1 UNION SELECT * FROM TABLE2 etc.