Access report – analysis of ratings

I need to produce a report which produces an analysis grid for the results of a series of 8 option fields.  To explain:
I have 8 fields to provide different ratings, such as “do you feel happier?”
These fields use option buttons on a form which set the database field to a value (1 to 5)
So I have 8 fields in a record that can each be set to a numeric value from 1 to 5.

I need a report to analyse this information in a grid such as this:

Question 1       Excellent [count]      Good [count]               OK [count]   etc
Question 2    Very much [count]    A little [count]     Not at all [count]   etc
etc

I have never produced a report like this before.  I could do it by creating a report containing subreports for each count.  That would require 40 subreports with 40 queries and seems a bit clumsy.  Is there a better approach to take before I start?

Hope this is all clear enough.

Regards

Richard