How to count and total check box values

[Cortney B]

I have a database of people who call into our office for assistance. They are designated by their location (A drop down menu with City/County/Out of County) and then the Nature of Problem is checked off (Eviction, Request for Housing, Implied Warranty) (Sometimes someone needs all three options).

I would like to show in a monthly report how many times a check box was clicked for the Nature of Problem and the location the call was from:

County
Eviction 5
Request for Housing 3
Implied Warranty 8
Total 16

City
Eviction 4
Request for Housing 9
Implied Warranty 2
Total 15

I am able to count all of the occurrences with =Abs(Sum([Nature of Problem-Request for Housing])) But how would I split that into County and City? If you could provide any assistance I would greatly appreciate it.

Query:
Q-County Monthly Participant Characteristic Report

Dropdown menu field in the Form is:
City/County/Out of County

Checkbox Field Names:
Nature of Problem-Eviction
Nature of Problem-Request for Housing
Nature of Problem-Implied Warranty

[Rabbit]

Do a group by on the location field.

SELECT ...
FROM ...
GROUP BY locationField

[Cortney B]

I attached a txt that shows the general layout of my report. I'm not sure how to implement the grouping with my current layout. I apologize for any confusion, I'm such a noob and still trying to learn. =)

I was able to separate out County totals in the Race/Ethnicity and tally the occurrences that populate from a drop down menu and organized with a query, with this: =Count((IIf([City/County/Out of County]="Lancaster County",1,Null)) And (IIf([Race/Ethnicity]="White",1,Null)))

The Landlord Tenant Info section shows County and City totaled, I am not sure how to separate out the County and still tally the check boxes to show only 12, not 20.

[Rabbit]

To progress, we need to know the SQL you're using for the report and the table structure of the tables that the SQL is referencing.