Week Ending Date

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!

Use the same method as how you arrived at the week numbers.
DateAdd("w",[YourWeekNumberField], #1/1/2006#)

"Baffee" wrote:

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!