I understand what resulting report should look like. To get it all you need is a cursor with 3 fields: Field, Category and Count. Put Category and Count in the Detail band. Create a group on Field and put Field in the group Header and Count in the Footer with Calculation=SUM and reset at the end of group.
I cannot help you with creating such cursor because you're avoiding questions about source of data for this report.
>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)!
--sb--