[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.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030718/b644df2c/attachment.html>