Subtotals in a report

I have a simple report which lists some data from a query
and uses a group header to split up the info. Some of the
info is an invoice value which I would like to compile and
total by group. I know how to add a subtotal to a normal
report but it only totals everything on the page as a
whole. How do I go about subtotalling specific data by
group?

Go to view on the menu bar and select 'Sorting and Grouping'

You can then add a group footer where you can add your total text box. To
add a footer select the appropriate group and then change group footer to
yes. When you run your report it should create a total after each group.

"Aaron Howe" wrote:

I have a simple report which lists some data from a query
and uses a group header to split up the info. Some of the
info is an invoice value which I would like to compile and
total by group. I know how to add a subtotal to a normal
report but it only totals everything on the page as a
whole. How do I go about subtotalling specific data by
group?

It all seems so obvious now you've said it :-D

Thanks very much!

-----Original Message-----
Go to view on the menu bar and select 'Sorting and
Grouping'

You can then add a group footer where you can add your
total text box. To
add a footer select the appropriate group and then change
group footer to
yes. When you run your report it should create a total
after each group.

"Aaron Howe" wrote:

I have a simple report which lists some data from a
query
and uses a group header to split up the info. Some of
the
info is an invoice value which I would like to compile
and
total by group. I know how to add a subtotal to a
normal
report but it only totals everything on the page as a
whole. How do I go about subtotalling specific data by
group?

.