Grouping Records in a report from Monday through Saturday.

[serino]

I have a report that I would like to group by the week and I am not sure how to go about doing this.

The report would use the [StartDate] field for sorting by the week and then subtotaling the [HRS] and providing a count for the amount of records within a weeks period.

The out come should look something like this.


SubDivision Zone CTCDTE STARTDATE HRS Count
322334 SW 05/24/2007 06/12/2007 7 1
343434 NW 04/04/2007 06/14/2007 3 1
232322 SE 04/23/2007 06/15/2007 4 1
__________________________________________________________
Total 14 3

SubDivision Zone CTCDTE STARTDATE HRS Count
436463 SW 05/02/2007 06/18/2007 5 1
534235 NW 05/04/2007 06/20/2007 4 1
325562 SE 05/31/2007 06/21/2007 2 1
__________________________________________________________
Total 11 3

Any help is greatly appreciated!

 

[traingamer]

...group by format([STARTDATE], "w")...

may get you started.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill