Time-based report with summary lists from all related items in related tables
I would like to know how to produce a summary report in my database of school bookings based on Terms (Spring, Summer and Autumn) for any given year.
Each booking in the found set will have multiple presenters drawn from a presenter table, and is for a specific school drawn from a schools table
As well as summary data on number of students, no of bookings etc (easyily achieved) I need a list of all active presenters for that term, and all schools presented in. I only need the schools and presenters listed once, even though often a school is visited more than once, and a presenter often does multiple presentations.
When I try to achieve this using portals, or using value lists calculated from related items, I only get one school and a list of the presenters from one booking.
I am sure there must be an easy way to do this, as it must be a common problem. Any suggestions would be greatly appreciated.