sum a group of fields in the report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ruzhena - 12 Oct 2005 16:52 GMT

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!

Reply to this Message

Duane Hookom - 12 Oct 2005 17:23 GMT

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

Signature

Duane Hookom
MS Access MVP
--

>I am having a problem with totalling the "Extended Price" field by Invoice
>in
[quoted text clipped - 10 lines]
>
> Thank you!

Reply to this Message