DB Setup and Reporting Dilemma HELP!

[gibsonmurphy]

I am having an issue with creating a report so please read this I am not sure if it should be under a table, query or report catagory.

First of all, My skill level in access is Basic Advanced - Always Learning. I work for an event company and we do many conferences where 1 attendee takes multiple classes.


The feed from the registration is in 1 table (and will have to stay in one table - so I would like for this to work based on this parameter). There is other information in the table too it is formatted as 1 line as follows: firstname, lastname, day1class, day2class, day3class, day4class, day5class, confirmation number(primary key) and additional event related columns. The reports that I typically run are a master list (providing all information in 1 report), a sign in sheet seperated by each class and day, attendee list and a daily class summary.



The last report mentioned above is the daily class summary. This report lists on 1 page every class and its totals for that day the report is 6 pages 1 for each day. My question is... how can I create a report that its first sorted by day, then by class on one page so I can see an "at-a-glance" of all days, classes and how many attendees. I am able to do this on multiple pages but again I want this on 1 page.

If you have further questions, Please let me know.

If this can be figured out I would SOOO greatly appreciate it.

[ItsMe]

Normalize your data by using additional table(s). You should be storing your day2class, day2class, etc. data in another table. Each class would have its own row/record in this new table. The key value for the associated student would be stores in a field in this new table as a foreign key value.

[gibsonmurphy]

Since the table that the data is fed into is tied into an online reporting system I cannot move the data into additional tables. So I need to know if it is at all possible to do this based on the condition the table is now. Does anyone know about Pivot Queries would this work??

[ItsMe]

How you export your data should have little to do with how you manage your data.