Grouping Totals

[Asif]

I have a report that displays the data from a query I'm running. The
report is grouped as follows

Bin Number
Skip Number
Quantity Date Cost

Now what I want to do is to display the total quantity and cost for
each bin just before a new bin number is displayed i.e. something like

Bin Number 12
Skip Number 23
Quantity Date Cost
132 15/06/07 £5.23
12 15/06/07 £8.23
TOTAL QUANTITY = 144
TOTAL COST = £13.46
------------------------------------------------
Bin Number 13
Skip Number 24
Quantity Date Cost
24 15/06/07 £2.23
182 15/06/07 £3.23
TOTAL QUANTITY = 206
TOTAL COST = £5.46

I've tried putting the Total Quantity and Cost Field in the "Report
Footer" Section but that just gave me the Total for all the Bins.

Any suggestions?

Thanks

 

[Guest]

Using the Sorting and Grouping create a Group Footer for the Bin field (You
might already have it).
In the Group footer create a text box, in it ControlSource write

=Sum([Quantity])

 

[Asif]

Using the Sorting and Grouping create a Group Footer for the Bin field (You
might already have it).
In the Group footer create a text box, in it ControlSource write

=Sum([Quantity])

--
Good Luck
BS"D

I have a report that displays the data from a query I'm running. The
report is grouped as follows

Bin Number
Skip Number
Quantity Date Cost

Now what I want to do is to display the total quantity and cost for
each bin just before a new bin number is displayed i.e. something like

Bin Number 12
Skip Number 23
Quantity Date Cost
132 15/06/07 £5.23
12 15/06/07 £8.23
TOTAL QUANTITY = 144
TOTAL COST = £13.46
------------------------------------------------
Bin Number 13
Skip Number 24
Quantity Date Cost
24 15/06/07 £2.23
182 15/06/07 £3.23
TOTAL QUANTITY = 206
TOTAL COST = £5.46

I've tried putting the Total Quantity and Cost Field in the "Report
Footer" Section but that just gave me the Total for all the Bins.

Any suggestions?

Thanks- Hide quoted text -

- Show quoted text -

Thanks Ofer works great