sum a group of fields in the report

[Guest]

I am having a problem with totalling the "Extended Price" field by Invoice in
the Report. The total should appear only at the end of the group of products
for one invoice, but it appears after each product line.

I created the Invoice Header with the Detail, and put the text box with the
formula (=sum([ExtendedPrice]) in the Invoice Footer. It still doesn't work.

Does anybody know the solution to this problem?

Thank you!

 

[Duane Hookom]

You should be able to total in any Group or Report Header or Footer section.
You can total fields or expressions from your report's record source. You
can't total a control from a different section.

If ExtendedPrice is the name of a control, your Sum() will not work. You may
be able to Sum() the control source of a text box:
=Sum([Quantity] * [UnitPrice] * (1-[Discount]))