Group data by weeks

[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

 

[Guest]

Look into the date functions and then group on it.

 

[dawn]

I have tried various different date functions for the last
few days and have not found anything that works

 

[Bas Cost Budde]

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.

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

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.