Creating a Summary of Grouped Data within a Report

[Gonzo18]

I have a report which groups data by line number. Within the line, I have textboxes which are performing SUM functions on the data from the query.

I have selected line 1-5 and the system displays exactly what I want, but I would like to take it a step further.

At the end of the report, I would like a COMPLETE sum of all the data displayed by the report. So the sum of line 1 + sum of line 2...... line 5.


Simple Graphical Representation as follows:

(note: total = ([bottles]+[caps]))

Line 1:

Bottles: 50 Caps: 55 Total: 105

Line 2:

Bottles: 50 Caps: 50 Total: 100

Line 3:

Bottles: 25 Caps: 25 Total: 50



(What I am looking for
TOTAL LINES:

Bottles: 125 Caps: 130 Total 2: 255


Could you please help?

Greg

 

[gol4]

in 1 text box
= "bottles:" & sum([bottles)" Caps:" & sum([caps]) & "total2 :" & sum([bottles] + sum([caps])

if your textbox names are bottles and caps this will work

 

[sunpines]

I have a similar question and am not sure I understand gol4's response. What I'm wondering is if there's some way to get a grand total in a group_by query? I'd like to put the grand total on my report as well as the subtotals by different type. Thanks for any assistance.

sunpines