B
Baffee
I have a subquery that I use in a crosstab quety. The subquery takes the
billable hours for each employee for the period from 1/1/06 to 4/29/06. It
looks at the worked date (wdate) and assigns the hours together by the week
#.
To get the week number I use: DateDiff("w",1/1/06,[wdate])
The crosstab then summarizes by the week and goves me a total by Employee by
week.
Everything works great.
The problem is that the crosstoab query shows the information as:
Employee Name 0 1 2 3 4 5...
Employee A 40 42.6 37 43 56 60 (These are hours)
I would like to show the week ending date (1/7,1/14,1/21 etc) instead of the
week number.
Any suggestions in how to do this in the subquery??
Thanks!
billable hours for each employee for the period from 1/1/06 to 4/29/06. It
looks at the worked date (wdate) and assigns the hours together by the week
#.
To get the week number I use: DateDiff("w",1/1/06,[wdate])
The crosstab then summarizes by the week and goves me a total by Employee by
week.
Everything works great.
The problem is that the crosstoab query shows the information as:
Employee Name 0 1 2 3 4 5...
Employee A 40 42.6 37 43 56 60 (These are hours)
I would like to show the week ending date (1/7,1/14,1/21 etc) instead of the
week number.
Any suggestions in how to do this in the subquery??
Thanks!