<!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>Jim:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thank you. Now all I have to do is get the
client to buy off on the time and $$ it will take to implement. :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV><FONT face=Arial size=2></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=jimdettman@earthlink.net href="mailto:jimdettman@earthlink.net">Jim
Dettman</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 4:00
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Record Count From
Group Header</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2>Rocky,</FONT></SPAN></DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial size=2><FONT
color=#0000ff><<But I'<FONT face=Arial size=2>ve got to get the number
of records in the group header.>></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2> The only way to do this is with a two pass report. On the
first pass, you place code in the Group Footers OnFormat event to capture and
store the total. On the second pass, you can then access that info and
place it anywhere on the page.</FONT></SPAN></DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2> To get a two pass report, you need to reference the pages
property. This forces Access to run the report once to get the total
number of pages, then a second time to print everything
out.</FONT></SPAN></DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2> The general technique is covered in this MSKB
article:</FONT></SPAN></DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><FONT color=#0000ff>ACC2: How to Reset "Page of Pages" Numbering for
Report Groups</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff size=2><A
href="http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q131/9/37.asp&NoWebContent=1">http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q131/9/37.asp&NoWebContent=1</A></FONT></SPAN></DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=460035122-07092003><FONT face=Arial color=#0000ff
size=2> Instead of storing the page numbers, you'll be storing the
totals.</FONT></SPAN></DIV>
<DIV><SPAN class=460035122-07092003></SPAN> </DIV>
<DIV><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of
WNY, Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></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>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Rocky
Smolin - Beach Access Software<BR><B>Sent:</B> Sunday, September 07, 2003
3:23 PM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> Re: [AccessD] Record Count From Group
Header<BR><BR></FONT></DIV>
<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></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>