Calculating Attendance

[Daryl2106]

Hi,



I am trying to calculate student attendance. Each two week period a faculty member will enter student attendance information into the StudentAttendanceT (from a form) that will include StudentNumber, ClassNumber, AttendencePeriod, ClassessAttended and ClassesOffered. The number of records with the same StudentNumber and ClassNumber will ultimatley equal the number of two week AttendancePeriods entered. I would like to be able to determine the total number of ClassesAttended and ClassesOffered on a continual bases (to date) in a subform and report as the year progresses. A third calculation to determine the % attendance from ClassessAttended/ClassesOffered will be added.

Any directions and suggestions will be greatly appreciated.

Take care,

Daryl

[alansidman]

Does this work for you

SELECT StudentAttendance.StudentID, Sum(StudentAttendance.ClassesAttended) AS SumOfClassesAttended, Sum(StudentAttendance.ClassesOffered) AS SumOfClassesOffered, [SumOfClassesAttended]/[SumOfClassesOffered] AS [Percent]
FROM StudentAttendance
GROUP BY StudentAttendance.StudentID;

Create a subform and make the query the recordset-

[Daryl2106]

Thnaks so much Alan,

That worked perfect! It was also a great lesson in SQL; to be able to see how the written code retrieves the desired records.

Again, thanks so much.

Take care,

Daryl