Hi,
I have a query based on a table - this table has many fields, with each field representing a report.
table looks like:
ActivitiesID . . . .employeeID.. dte. . . report 1...report2..report3..
Now, I know this table is not normalized, and an obvious solution is to normalize is, but it's too late! I started developing this application without any prior knowledge and this report is the last thing I have to create.
My manager wants a report which looks like the file I attached.
How can I approach this? Is there anyway I can make this work without having to do alll the work again
please help!!!
I have a query based on a table - this table has many fields, with each field representing a report.
table looks like:
ActivitiesID . . . .employeeID.. dte. . . report 1...report2..report3..
Now, I know this table is not normalized, and an obvious solution is to normalize is, but it's too late! I started developing this application without any prior knowledge and this report is the last thing I have to create.
My manager wants a report which looks like the file I attached.
How can I approach this? Is there anyway I can make this work without having to do alll the work again
please help!!!