Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Need Count of records in Group Header

Posted on 2008-11-17
Medium Priority
Last Modified: 2012-05-05
I created a Running Total to count the number of records being displayed for each Group.  It works fine when I place it in the Group Footer, but I would prefer to display it in the Group Header.  Can it be done?
Question by:CarlaGibson
  • 2
LVL 26

Expert Comment

ID: 22979633
sure you can.
just drag the sum from group footer to the group header. since thay are grouped within the same group the result will not change.
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 22979895
You can't.  A running total is calculated during the printing pass and will be 0 in the group header.

Assuming you are counting all records in a group try this
Right click one of the fields in the detail sectiion
Set it as COUNT for the summary type
Put it in the group footer

You can drag the summary to the group header.


Author Comment

ID: 23013537
This is no longer needed by the people who requested that I do it.  I have not had a chance to test out the code provided.  I'll give the points to mlmcc for taking the time to answer.


Author Closing Comment

ID: 31517614

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses
Course of the Month11 days, 13 hours left to enroll

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question