Trying to create a Report (calendar style) based on Weekly Activities

[tim_tims33]

HI,
I have created a table for a Gym that shows which classes / activities are on which days. You will notice in the image below that i have assigned Boolean to associate a class with a day of the week.

I now am trying to create a Calendar STyle report that GROUPS all activities by the day they are on. So, for example, see below:

As you can see, all of Monday's activities will appear first (in a group) followed by Tuesdays.

One way I think i could achieve this is by doing a QueryMonday, QueryTuesday...etc so i have dataset or resultsset for each day. Then i could bring into a report, each query as a sub-report. I believe this is overly complex for what i'm trying to achieve. Also, using 5 gropuing levels in one report doesn't achieve it either.

Any help would be much appreciated.
Thanks,

[pbaldy]

I would probably create a UNION query to normalize the data, and base the report on that (grouping on day).

[NTC]

the proper table structure is:
Class Name, Day of Week

so that would be your stack of data properly normalized.... then everything else is presentation....

your top example is a cross tab...your bottom example is grouping....