<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>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'</FONT><FONT face=Arial
size=2>ve got to get the number of records in the group header. Maybe I'll
try counting the On_Print events for group header.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks and regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access Software</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=stephen@bondsoftware.co.nz
href="mailto:stephen@bondsoftware.co.nz">Stephen Bond</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, September 07, 2003 11:55
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Record Count From
Group Header</DIV>
<DIV><FONT face=Arial size=2></FONT><BR></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2>A way I know of to count the records in a Group is to put a
hidden text box on the detail line.</FONT></SPAN></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2> Name: txtCount</FONT></SPAN></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2> ControlName: =1</FONT></SPAN></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2> RunningSum: Over Group</FONT></SPAN></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2>Then the count per group (txtCount) is available in each group
footer. </FONT></SPAN></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2>Stephen Bond</FONT></SPAN></DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688244918-07092003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rocky Smolin - Beach
Access Software [mailto:bchacc@san.rr.com]<BR><B>Sent:</B> Monday, 8
September 2003 4:57 a.m.<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Record Count From
Group Header<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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?.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I believe I've seen this syntax generated by
the wizard but can't duplicate it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>