Help creating summary report
I need to create a summary report that will total all participants in a particular category by grade. For example: It should look like a grid with grade levels (6 Grade levels) going down the left side and categories (7 Categories) going across the top. The body of the grid will contain the number of students from each grade level in each category.
I have a table of "Students" and a table of "Projects". Projects has the category and grade and Students has the category and grade also.
Do I need another table to do the summary from? I need help on creating this report, so hopefully you can help.