3 Table Values in one query

[Wong]

Hi
I have looked at the forum to see if I can find my answer, but it doesn't seem to be there.

I have 3 tbl SchoolDetails, School Activities and Keystages

The values from each table SchoolDetails ID & School Name
SchoolActivities: Activity Title, Date, Start Time, No of Workshops
Keystages: Keystage and NoOfPupils

I am trying to send one confirmation to each school. My problem is that when we book out the time it is booked out either by HalfAM or HalfPM, therefore if a school books a full day they get 2 records in the SchoolActivities tbl.

They also get numerous records in the Keystage tbl depending on how many classes are involved.

I am trying to bring together the sum of NoOfPupils - even though this can have two records (AM & PM) and also the numbers can be in numerous records in Keystage.

I just need to know how best to do this.

Any help would be appreciated.

 

[Wong]

I have tried a Totals query, but it only totals the values for the Keystage ID and not for the actiitiesID, am I doing something wrong!