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.