[AccessD] Counting group headers in a report (FAQ)

bruce,

    Following course of action is suggested
    (1) Counting the number of groups
        (a) Place a calculated text box named grpcnt, having expression =1 in the group footer (as already done by you). Set it's RunningSum property to OverAll.
        (b) Place a text box named TxtTot having expression =[grpcnt] in report footer. This text box (as well as the one in last group footer) will display the total count of groups.
    (2) Counting the number of records in each group. 
        (a) Use the expression = Count(*) in the text box in group footer.
        (b) If progressive totals are needed, set the RunningSum property to OverAll, otherwise set it to None.
    (3) Counting the grand total number of records in the report.
        Place a text box having expression = Count(*) in report footer.

Best wishes,
A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: Bruen, Bruce 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, November 15, 2005 10:19
  Subject: [AccessD] Counting group headers in a report (FAQ)


  ...  I've done this a zillion times....
   
  A colleague asked me how to get a count of the group headers in report.
  He has a query based report that has a single group header/footer and wants just the summary report, so he makes the group header and detail sections invisible (a neat trick to get a quick summary report that I'd never thought of by the way.).  Now he just wants to count the group footers and put that count into the report footer.
   
  So I just popped an unbound textbox into the footer, named it grpcnt and set its value to =1 and in the report footer I put another unbound textbox with value =Sum([grpcnt]).  I am sure I've done this before!!!  
   
  A97 thinks that [grpcnt] is some type of parameter for the report and pops up a parameter entry form when I run the report.
   
  Erstwhile MSAccess guru exits stage left with egg on face and begs AccessD'ers for the solution.... 
   
  bruce