Count of Groups in a Report, Groups Not Records - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Count of Groups in a Report, Groups Not Records

Robert Blanchette

12 days ago

Screen capture will follow.
I have a report that has 2 levels of grouping, a group having multiple lines of detail.
When I ask for a count of the records, I end up with the total number of records.
When I use the "show no details" of the report, I still see the total number of records.
I would like to see only the number of lines (groups) shown.
I tried my best to describe the problem with the annexed screen capture.

	Kevin Robertson @Reply 12 days ago
Use the Header/Footer of the Group to get the number of records in that Group.

	Robert Blanchette OP @Reply 12 days ago

	Robert Blanchette OP @Reply 12 days ago
Kevin Sorry, I just uploaded the screen shot which will (I hope) clarify my need. I need to see the number of lines in the report without details as opposed to the number of records. Thanks

	Kevin Robertson @Reply 12 days ago
Is this what you are looking for?

	Kevin Robertson @Reply 12 days ago
Numbered Report Items cover the Running Sum property. To hide the details make the section not visible.

	Kevin Robertson @Reply 12 days ago

	Robert Blanchette OP @Reply 12 days ago
Thanks for your rapid response and the time you spent on this. I easily can reproduce what you suggest. However, I have some issues reproducing it with my own report. I will work on it some more and let you know how it goes. Thanks again. Please do not close this post for the moment

	Robert Blanchette OP @Reply 9 days ago
My report now looks exactly as I wanted it to. I struggled to have a count of the groupings. Let's say I have Group 1 and Group 2. Easy to get the number of records in group 2 in the footer of group 2. I struggled to get the number of distinct group 2 in the footer of group 1. Thanks again

Next Unseen