Sum items based on dates

[rafeman]

Hi, I have the following table

PRIMARY DATE GROUP
1 10/08/08 Residential
2 12/08/08 Self Build
3 10/08/08 Self Build
4 11/08/08 Domestic
5 09/08/08 Residential

The user wants a report as following;

Parameter (Date)

Qty Tasks Qty Tasks Qty Tasks Qty Tasks Qty Tasks
Day Yesterday Week Month YTD

So by entering 10/03/08 we get

2 1 5 5 5

I have no idea of a method on how to achieve this other than running totals. Can anyone point me in the right direction.

This will also be grouped by Residnetial etc.

Thanks

 

[lbass]

If you are grouping by "group" and you want a summary by date intervals in the report footer, then running totals are the way to go.

-LB