All workshops ever? Just in a date range? Which schools attended a specific session? or?
For this occasion, yes - all occasions with the amount of teachers and children present.
I would also like to know, can I do a 'quick' thing (for a lack of better words), if I am asked on the fly to gather specific information such as 'Which schools from Area 1 attended all the 2009-2010 sessions, include teachers and children.
If I remember right, Workshop line items lists the students and teachers for each session.
Try creating a layout based on that table occurrence, but add fields from sessions, Areas and Trustees so that you can enter find mode and enter criteria in each of these.
You can probably display the results in a summary report that groups the records either by session, school and/or area to report the results you need.
Thank you for the help. I was able to pull the information I was looking for, but I am still unsure of making my report look readable. I ended-up saving it in excel and changing a bunch of things - which was a lot of work. Can you point me in the right direction of making reports look nice?
If you are generating a report that groups entries into categories, possibly with sub-totals and grand totals (and counts, averages, etc), you are likely to need a summary report layout.
Here's a tutorial on Summary Reports that may get you started on some possibilities: