Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

dporrelli

Programmer
Dec 18, 2002
43
GB
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.
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top