View Full Version : Grouping using different months


spnz
05-04-2005, 07:11 AM
Good afternoon,

The report I am using is grouped by dates.

What I am trying to is display a total of the records within the group. Very easy I just used the =count([datefield]) and it gives me the total.

What I would like to do is have the month showing plus the count formulas result, here is an example


19/04/05
20/04/05
21/04/05

Total for April = 3

01/05/05
02/05/05

Total for May = 2


Can anyone suggest what I need to do.


Thanks in advance!!!

spnz
05-04-2005, 02:07 PM
Managed to finally work it out.

This is what I used to achieve my goal.

="Total Booked Holidays For " & Format([enddate],"mmmm") & " = " & Count([enddate])

Thanks