Summing value in Grouped Section

[Don]

Hello, I have a report that is based on 2 tables (Invoice and InvoiceDetail),
the detail section of the report shows data from InvoiceDetail and I have a
group section on the InvoiceID. On the InvoiceID footer and report footer, I
sum some of the values from the detail such as Qty (ie =sum(Qty)). Some of
my columns only exist at the invoice level such as Freight. My query that
the report is based on returns a column for Freight that is the same for each
row with the same InvoiceID. I just show this field in the InvoiceID group
section. How do I get it to sum in the report footer. If I do =sum(Freight)
the value will be to large as I have multiple detail rows per InvoiceID.

Thanks

 

[Allen Browne]

Use a running sum text box to accumulate the value across the invoices of
the report.

In the InvoiceID group footer, add a text box with these properties:
Control Source Freight
Running Sum Over All
Format Currency
Visible No
Name txtInvoiceIdFreightRS

Now in the Report Footer section, add a text box with Control Source of:
=[txtInvoiceIdFreightRS]