[AccessD] Report Totals

Because the underlying table *does* contains multiple records for the same
case number, I think the only way you are going to be able to display the
number of CASES reported on is to have a second query, based on the query
that the report details come from. The second query will just be

SELECT DISTINCT CaseNumber From FirstQuery

save this as (say) CaseList_qry

... with that query available, to get your count of case numbers enter the
following in the report footer control's datasource property

=DCount("CaseNumber","CaseList_qry")

Lambert

> -----Original Message-----
> From:	Mark Boyd [SMTP:MarkBoyd at mcbeeassociates.com]
> Sent:	Friday, July 18, 2003 3:40 PM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [AccessD] Report Totals
> 
> Charles -
> I've tried this, but it still returns the actual record count.
> For example, if there are 5 detail records, the counter in the header
> equals 5, even though there is only 1 case number displayed in the
> header record.
> 
> Mark
> 
> -----Original Message-----
> From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
> Sent: Friday, July 18, 2003 3:28 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [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.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com