How to add subtotals on report groups

[WeberBK]

I'm a novice at Access.
I used the report wizard to create a report that sorts about 200 records into groups by customer name, part number and quantity.

I need to add a sub total to the bottum of each group.

Can I do this in design view?

Bill

 

[Sammy B]

I believe you can. If you have created 'Groups' on your report then you will have a group header and group footer. If so then this is the plan:

Inset a text box in the group footer. Let us say you need to total the 'quantity’ from the group. (Make sure you know the name of the text box you wish to sum.. in this example I will assume its name is ‘quantity’)

In the newly formed test box’s ‘Control Source’ type in the following:

=sum([quantity])

If you wish a grand total then put a test box in the report footer with the same text in the ‘Control Source”