C
chemicals
I have a table that contains:
Project, Phase, StartDate, Month1, Month2, Month3,...Month48
Ecah Month column contains the number of hours spent in that month on the
project. The Month columns are not dates.
I am trying to query the projects so that I can align all of the columns of
hours based on the current month.
For example is the data was:
Proj A, Build, 2/08, 5,10,15,20,...240
Proj B, Build, 5/08, 1,3,5,7,...97
Proj C, Build,11/07, 2,4,6,8,...96
The output would be:
Proj A, Build, 2/08, 30,35,40,45,...240 (skips 1st 5 months)
Proj B, Build, 5/08, 5,7,9,11,...97 (skips 1st 2 months)
Proj C, Build,11/07, 20,22,24,26,...96 (skips 1st 9 months)
I am having trouble getting my hands around this...
Thanks
Project, Phase, StartDate, Month1, Month2, Month3,...Month48
Ecah Month column contains the number of hours spent in that month on the
project. The Month columns are not dates.
I am trying to query the projects so that I can align all of the columns of
hours based on the current month.
For example is the data was:
Proj A, Build, 2/08, 5,10,15,20,...240
Proj B, Build, 5/08, 1,3,5,7,...97
Proj C, Build,11/07, 2,4,6,8,...96
The output would be:
Proj A, Build, 2/08, 30,35,40,45,...240 (skips 1st 5 months)
Proj B, Build, 5/08, 5,7,9,11,...97 (skips 1st 2 months)
Proj C, Build,11/07, 20,22,24,26,...96 (skips 1st 9 months)
I am having trouble getting my hands around this...
Thanks