I do have a tendency to over-think things, but i don't think it's that simple. I will try to explain better.

Need to list many fields (e.g., audience type, audience size, materials type, staff role) and for each field, list the value categories (e.g., For audience type: Classroom, community group, professionals, police, other), with counts for each
value. Then a total count of all category values for each field. Must be done for many fields all on one report.

Example:
Field: Materials Type
Categories: Handout, Workbook, Video, Evaluation, Other
Must calculate/list counts for how many Material Types were handouts, workbooks, video, evaluations, or other.
Must sum all counts for each category to give a total for the field.
Must be done for many fields, (e.g., Audience Type, Audience Size, Materials Type, Staff Role, etc.) on one report.

If i could attach an example of what the output should look like, maybe that would help.

Give it to me staight! If i'm being dense, please let me know (hopefully with an explaination)!

Thanks.
NK