Group report in 4 week periods?

[Franky G]

Hello,

I would like to run a report which will tell me the fees received in 4 weekly periods, starting 01/04/2001. So I would end up with a list like Period 1 - 01/04/2001 to 28/04/2001 : £2m , followed by Period 2 - etc etc. I know how to extract the fee information, but I don't know how best to have it grouped in the 4 week intervals I want.

It would be Ok if I had to create a new form with lots of 'From' and 'To' fields on it, but I think that’s quite clumsy, I'm sure there must be a better way of doing it. Any help would be appreciated

Thanks

Frank.

 

[dynamictiger]

I am not absolutely certain but would think that 4 weeks always contain 28 days. I know sometimes it seems 4 weeks contain about 200 days.

That being the case a dateadd loop could be written.