subtotals in report

[Patti]

Is there a way to subtotal data by month if I group my data
by the date field (i.e.: 6/19/03, 6/23/03, 7/24/03,
11/04/03 etc.)

 

[Marshall Barton]

Is there a way to subtotal data by month if I group my data
by the date field (i.e.: 6/19/03, 6/23/03, 7/24/03,
11/04/03 etc.)

Try adding a group level with footer on the expression
=Format(datefield, "YYYYMM")
and move the group up above the date group.

Now you can use a text box in the month group footer with
the expression =Sum(somefield)

 

[John Spencer (MVP)]

Yes, in the sorting and grouping dialog when you use a datefield to group on you
can set the Group on property to Month (also other units of time). Before this
option is available (or at least working) you must set a group header or group
footer to yes for this group

This automagically groups by the year and month.

 

[Patti]

Thanks, Marshall. it was exactly what I was looking for!