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