display a total of all values in a field at end of a report

[dporrelli]

I am creating a stock report and at the end of each section I want to put a sub total, then at the end of the report put a grand total.
Any help would be greatly appreciated.

 

[GHolden]

Assuming each section is a group on the form..

In the Group Footer put an unbound textbox with..

=Sum([FieldName])

In the control source

And repeat the same in the Report Footer to get a sum for the whole report.

There are two ways to write error-free programs; only the third one works.

 

[jebry]

Hi!

In the report footer put a text box with the control source =Sum(YourField). This will give you the grand total for that field. Of course, this will only work with a field that is part of the record source of the report.

hth
Jeff Bridgham
bridgham@purdue.edu