One Big Table??

[Mike.Howard79]

Hi all,

I have 12 tables which I need to merge into one big one if that makes sense?

Eg

Employee Name
Start Date
Progress Report Out
2 Week
4 Week
6 Week
8 Week

All tables are set out like this but are broken down into departments. I now need to create one big table with:

Employee Name
Start Date
Progress Report Out

So I can create a "Main" report rather than departmental breakdown.

Can anyone help?

Much Appreciated

Mike

 

[boblarson]

If these

2 Week
4 Week
6 Week
8 Week

are supposed to be columns then the tables are structured incorrectly.

But if you just want this data for a report, then use a UNION Query. There is no need to build another table.

You can even add a field just in case you want to group by department too.

So like this:

SELECT [Employee Name], [Start Date], [Progress Report Out], [2 Week], [4 Week], [6 Week], [8 Week], "DepartmentName1" As Department
UNION
SELECT [Employee Name], [Start Date], [Progress Report Out], [2 Week], [4 Week], [6 Week], [8 Week], "DepartmentName2" As Department
UNION
SELECT [Employee Name], [Start Date], [Progress Report Out], [2 Week], [4 Week], [6 Week], [8 Week], "DepartmentName3" As Department
... and so on