I want to total a particular group

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Suby - 12 Jan 2007 07:31 GMT

Folks,

I have a report based on outlets turnover. Records are grouped according to
outlets. There may be multiple outlets whose total should be calculated. I
tried running sum, but I am looking individual group sum not cumulative
(running sum). Any idea

Reply to this Message

John Spencer - 12 Jan 2007 16:21 GMT

Add the group footer and use a control in the footer with its source set to

=Sum([some field])

Make sure the control does NOT have the same name as any field in your
report.

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Folks,
>
[quoted text clipped - 3 lines]
> tried running sum, but I am looking individual group sum not cumulative
> (running sum). Any idea

Reply to this Message