count of sum of records

cft

Registered User.
Local time
Today, 18:32
Joined
Dec 31, 2001
Messages
52
I have a query used to drive a report. The report is to list each record grouped by rnCode by state (e.g. NY, NJ, CA, etc...). The report displays all records under each code for each state. I have been able to display the count (total) of the number of records for each code by creating an unbound box on the report with "=Count([rnCode])". Now I need to SUM the totol counts of records for ALL codes for that state. IE: State NY Code1 = 3, Code 2 = 3, Code 3 = 3, etc... then the Sum of the Count of Codes = 9. How do I get the query (or report) to show the sum of the Counts by State? Any help will be appreciated.
 

Users who are viewing this thread

Back
Top Bottom