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