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) )...
User Profile
Collapse
-
How to count and total check box values
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...
No activity results to display
Show More
Leave a comment: