[AccessD] Record Count From Group Header

I think you're right about the sub-report.  That would work.  But I'm trying to avoid that and just get the number of records in the group header.  The running sum control would work for counting the detail records in each group.  But I've got to get the number of records in the group header.  Maybe I'll try counting the On_Print events for group header.

Thanks and regards,

Rocky Smolin
Beach Access Software
  ----- Original Message ----- 
  From: Stephen Bond 
  To: Access Developers discussion and problem solving 
  Sent: Sunday, September 07, 2003 11:55 AM
  Subject: RE: [AccessD] Record Count From Group Header


  A way I know of to count the records in a Group is to put a hidden text box on the detail line.

     Name: txtCount
     ControlName: =1
     RunningSum: Over Group

  Then the count per group (txtCount) is available in each group footer.  

  The only way I found to put all the group counts into the *Report* footer is by using a subreport in the Report Footer which has a Totals query as its Recordsource.

  Stephen Bond



    -----Original Message-----
    From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
    Sent: Monday, 8 September 2003 4:57 a.m.
    To: AccessD at databaseadvisors.com
    Subject: [AccessD] Record Count From Group Header


    Dear List:


    Is there a way to extract the record count from a group header and put it into a control in the report footer?  =Me.Count gives me the count of the detail records.  =[Count] gives me the count of detail records.  [GroupHeader3].[Count] gives me #Name?.

    I believe I've seen this syntax generated by the wizard but can't duplicate it.

    MTIA,

    Rocky Smolin
    Beach Access Software



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030907/f623039c/attachment-0001.html>