getting qry in 1 to many relationship..!!! Help Please~~

[mk2lee1]

Hi, I have this table called school, participation, and answer registration.
currently i have this qry
==================================================
SELECT [school].[schoolname], sum([participation].[numberofstudents]) AS totalStudent, sum([answerRegistration].[#Folders]) AS totalfolders
FROM school LEFT JOIN (participation LEFT JOIN AnswerRegistration ON [AnswerRegistration].[ParticipationID]=[Participation].[ParticipationID]) ON [school].[schoolid]=[participation].[schoolid]
GROUP BY [school].[schoolname];
==================================================
this query gives schoolname, number of students and number of folders. However I would like to add, the test date, which is a field in participation. Problem is one school can have more than one participation, and this qry is grouped by school. Is there a way that I could get the all these days.. school and its different participation.testDate?
please help me out on this.. thanks~~

 

[mmsbasd]

I would just make a separate query for the test date and then make a JOIN query to show all the information in one place. In most cases, I find that this is the easiest (and sometime the ONLY) way to put this kind of information together. Hope this helps.

Michael
BASD IS/IT Dept

 

[mk2lee1]

how do i do that?