Thread: How to make Attendance Database

Hello all,

I am trying to build a database tracking team members attendance. there are 2 major tables [tblAttend] and [tblEmployee]; linked together by field [EmployeeID].
Team Members gain points for absences but they have a chance to earn back 1 point for every two months of perfect attendance (filtering categories such as sick, absent, and late). 1 year after their absence the points that they've earned will drop off. how do I build a query that will subtract points earned in year increments, and subtracting 1 point every two months of perfect attendance.

please give possible suggestions

Thanks

Here is the format of Attendence Database May this should help you.

Attendance Format.xls