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
Bookmarks