I've solved my problem. For those that are interested I created a query for each house:
SELECT qryPlacePoints.House, [Sum Of Adelong]+[SumOfPoints] AS TotalAdelong
FROM qryParticipation, qryPlacePoints
WHERE (((qryPlacePoints.House)="Adelong"));
Then...
New query to bring all the totals...