subtotals in report

P

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.)
 
M

Marshall Barton

Patti said:
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.)
Click to expand...

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)
 
J

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.
 
Top