Group Rows by Subtotal or Count

  • Thread starter Thread starter Rskinner4
  • Start date Start date
R

Rskinner4

Have a report that has 97 rows and I want to "Subtotal" the Count of Rows to
30, so I would end up with three "groups" of 30 and one "group" of 7.
However, all the group, sort, and totals are by field or names. Once I have
them in Groups of 30, I want the Subtotal amount for that group. How do I
create this Subtotal Count in the Field Footer of the Report? Thanks.
 
Rskinner4 said:
Have a report that has 97 rows and I want to "Subtotal" the Count of Rows to
30, so I would end up with three "groups" of 30 and one "group" of 7.
However, all the group, sort, and totals are by field or names. Once I have
them in Groups of 30, I want the Subtotal amount for that group. How do I
create this Subtotal Count in the Field Footer of the Report?
Click to expand...

To do grouping on a linenumber kind of thing, the line
number nust be a field ib the report's record source query.

If you have a way to sort the records, then you can use a
subquery in a calculated field to do it:

LineNum: (SELECT Count(*) FROM table As X WHERE X.sortfield
< table.sortfield)

Then the report can group on the expression:
=LineNumber \ 30
 
Back
Top