need help on gettin the sql query in access. Plz Help~~

[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~~

 

[Rolliee]

This requires code as a sum is associated with more than one date isn't it? If you need code, give your tables, their fieldnames and what you wish again and I will show you the code.

rollie@bwsys.net