I am creating a report that would generate a Summary report for Student Activity Attendance. Every student can attend multiple activities, and my
report group by student, name, and activity. Then I sum the attendance for
each individual activity, as compared to the required attendance ( I get this
from count of activity record). Next comes the Total Attendance for each student. I use Sum(SumofAttendance), Access prompt me with "Subquery can't be used in Sum of Sum" error.
I read your old discussion, and you are POSITIVE that I can "Sum the Sum".
The only difference is that this is a QUERY I use in my report.
I use Acces 2002 version.
How to FIX this error and go on?????
Below is the query---------->
SELECT [Dayly Attendance].StudentID AS Lynn, Student.LastName, Student.FirsName, [Dayly Attendance].ProgramNumber, Sum([Dayly Attendance].Attendance) AS SumAtt, Count([Dayly Attendance].ProgramNumber) AS SumSec, Sum([SumAtt]) AS SumMonAtt, Sum([SumSec]) AS SumMonSec
FROM Student INNER JOIN [Dayly Attendance] ON Student.StudentID = [Dayly Attendance].StudentID
WHERE ((([Dayly Attendance].Date) Between #3/1/2007# And #3/30/2007#))
GROUP BY [Dayly Attendance].StudentID, Student.LastName, Student.FirsName, [Dayly Attendance].ProgramNumber
ORDER BY Student.LastName, Student.FirsName, [Dayly Attendance].ProgramNumber;
THANKS for A TONS............
Lynn