Grouping Totals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asif - 15 Jun 2007 10:33 GMT

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

Reply to this Message

Ofer Cohen - 15 Jun 2007 11:02 GMT

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])

Signature

Good Luck
BS"D

> I have a report that displays the data from a query I'm running. The
> report is grouped as follows
[quoted text clipped - 28 lines]
>
> Thanks

Reply to this Message

Asif - 15 Jun 2007 15:10 GMT

On Jun 15, 11:02 am, Ofer Cohen <OferCo...@discussions.microsoft.com>
wrote:

> Using the Sorting and Grouping create a Group Footer for the Bin field (You
> might already have it).
[quoted text clipped - 40 lines]
>
> - Show quoted text -

Thanks Ofer works great

Reply to this Message