SELECT COUNT(tblStu_Attendace.Status) FROM tblStu_Attendace GROUP BY tblStu_Attendace.StudentID WHERE tblStu_Attendace.Status='P'
SELECT COUNT(tblStu_Attendace.Status) FROM tblStu_Attendace WHERE tblStu_Attendace.Status='P' GROUP BY tblStu_Attendace.StudentID
SELECT tblStu_Attendace.StudentID, COUNT(tblStu_Attendace.Status) FROM tblStu_Attendace GROUP BY tblStu_Attendace.StudentID WHERE tblStu_Attendace.Status='P'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)