Group data by weeks

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

Hello All,
In a crosstab query I want to group data by the week. For
example, the date range specified is Feb 1 to Feb 29, I
need the Crosstab to return 4 weeks. So data from Feb 1
to 7 is summed in Week1, data from Feb8 to 14 is in Week2,
etc

Thanks
 
I have tried various different date functions for the last
few days and have not found anything that works
 
Dawn said:
Hello All,
In a crosstab query I want to group data by the week. For
example, the date range specified is Feb 1 to Feb 29, I
need the Crosstab to return 4 weeks.
Click to expand...

That is 5 weeks, actually. Or do you mean "up to and not including"?

So data from Feb 1
to 7 is summed in Week1, data from Feb8 to 14 is in Week2,
etc
Click to expand...

That is a little difficult; you can use format(yourdate,"ww") to get the
week number, and subtract the value of the first week to arrive at number 1.
 
Back
Top