[AccessD] Report Totals

Mark,

Put a counter in the group header and then display its value in the
report footer.


Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] 
Sent: Friday 2003 Jul 18 12:51
To: AccessD at databaseadvisors.com
Subject: [AccessD] Report Totals

I have a table with 100 non-unique Case Numbers (most are repeating),
along with other fields.
In a report, I put this field in the Case Number Header, and the other
fields in the Detail section.
How can I get a count of the case numbers that are actually displayed in
the report?
When I put Count([CaseNum]) in the footer, I get the total case number
count in the table, not what is displayed.
Any ideas?

Thanks,
Mark Boyd
Sr. Systems Analyst
McBee Associates, Inc.