Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count Total Records for a group-- Start Over for next group

Status
Not open for further replies.

Bentk

Programmer
Feb 18, 2005
9
US
I have a report that I need to count the records for each group. First group A. has 16 records returned. Second group B. has 25 records returned. When I use the function recordcount it returns back 41 records for every group. I need it to give me an individual record count for each group. Any Ideas?

Thanks,

Bentk
 
Right click one of the fields in the details section and choose Insert, Summary.
Change the summary type to SUM, and the location to the group.

~Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top