How to Count the number of records in a Group

[davemckie]

Hi all,

I need a formula that will count the number of records per group. I need it to track how many records per page. Can anyone reply with a sample?

thanks in advance
dave

 

[rhinok]

The easiest way to do this is to create a Running Total Field that counts occurences of a field in the group and then resets on Change of Group.


~Kurt

 

[MColeman]

You could use a running total that resets on group change.

In the Field Explorer, click on Running Total Fields and select New from the toolbar.

1. Name your running total field.
2. Choose which detail field this summarizes.
3. Set type of summary to count.
4. Make sure evaluate for each record is set.
5. Choose reset on change of group and select which group.

Click ok, and place running total field in the group footer.

 

[davemckie]

Wow....easier than expected.
Thanks dave