Chris Lynch
Registered User.
- Local time
- Today, 18:26
- Joined
- Apr 14, 2005
- Messages
- 39
Hi all
I have the following query that will show the date, studentname, number of classes marked absent for that date.
i also want to show the total number of classes in the day, this is needed to make a quick comparsions to the total number of classes missed per day.
This is the code
This shows the date, the number of classes the student was absent for, the student name, the total number of class in that day.
But my problem is that it only shows the total number of classes marked absent again..... IS there a way to exclude the where clause from the Count(Attendance.ClassID) AS CountOfClassID part of the code...
Help is is welcome
Thanks
Chris Lynch
I have the following query that will show the date, studentname, number of classes marked absent for that date.
i also want to show the total number of classes in the day, this is needed to make a quick comparsions to the total number of classes missed per day.
This is the code
Code:
SELECT Attendance.Date, Count(Attendance.Attended) AS CountOfAttended, Student.StudentName, Count(Attendance.ClassID) AS CountOfClassID
FROM Student INNER JOIN (Groups INNER JOIN (Classes INNER JOIN Attendance ON Classes.ClassID = Attendance.ClassID) ON Groups.GroupID = Attendance.GroupID) ON Student.StudentID = Attendance.StudentID
WHERE (((Attendance.Attended)=' Absent'))
GROUP BY Attendance.Date, Student.StudentName, Student.StudentID
HAVING (((Student.StudentID)=[Forms]![Frm]![cboStudent]));
This shows the date, the number of classes the student was absent for, the student name, the total number of class in that day.
But my problem is that it only shows the total number of classes marked absent again..... IS there a way to exclude the where clause from the Count(Attendance.ClassID) AS CountOfClassID part of the code...
Help is is welcome
Thanks
Chris Lynch