Perfrom summations/counting for grouped fields in access report

[mhegazy]

I have built an access report that works as a stepped report based on grouped fields.

When perfroming sum or count for the one of the grouped fields, access always yields the sum/count of the individual records in the details section, even when set the sum/count function as to work on values.

For example, the report has 5 groups each one has two records of details, so acccess did not count 5 for the grouped fields, but rather 10 as the total number of records in the report.


Could someone help me in doing this.

thanks in advance,

mhegay

[zmbd]

this really hasn't changed since ACC2003
http://office.microsoft.com/en-us/ac...001122444.aspx will explain the foundations.

If that isn't quite right then you can take a look here:

http://office.microsoft.com/en-us/access-help/create-a-grouped-or-summary-report-HA010341571.aspx

Finally, this really just bare bones:

http://office.microsoft.com/en-us/access-help/summing-in-reports-HA010120854.aspx

Of course, if none of these help, post back... we'll need more detail about the underlying recordset and formatting that you're using in order to help... which once you read thru the above links you'll have a better idea of what information we need.

-z

[NeoPa]

You are counting the number of individual records rather than the number of groupings.

In a report, there is no straightforward way to count groupings, but you could add a control on the group footer of the group you wanted to count and specify that it's a running sum. That way a reference on the higher-level group footer to this control would give you the grouping count. The value in the control should be 1 of course.