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 increaments, and subtracting 1 point every two months of perfect attendance.

I appreciate your help

Bishop2ya