Combining Tables into one table

[softspoken]

I have 6 tables that have the same Column headings but different data that I need to combine into one table.

Can anyone explain in detail as I am a novice user how to do this.

Thank you

[maximus]

You can use a Union Query to combine the tables to display all information from all the tables in a single query. example


SELECT [Aging_2004_2006].[Srl_No], [Aging_2004_2006].[Remarks], [Aging_2004_2006].[Followup_Date]
FROM Aging_2004_2006
WHERE ((([Aging_2004_2006].[Followup_Date])=#4/8/2010#));
UNION SELECT [Aging_2007_2008].[Srl_No], [Aging_2007_2008].[Remarks], [Aging_2007_2008].[Followup_Date]
FROM Aging_2007_2008
WHERE ((([Aging_2007_2008].[Followup_Date])=#4/8/2010#));

I have two tables and I have used a Union Query to combine them

The Tables are Aging_2004_2006 and Aging_2007_2008

Note: Union Queries are not editable.

[softspoken]

that worked thank you very much