Hello everyone, I have a question. I have two tables Employees which holds all the employee information with the following fields:
EmployeeID - Text (Primary)
DepartmentCode - Text
DateOfHire - Date/Time
FirstName - Text
LastName - Text
Seniority # - Number
WorkDays - Number
I also have an activityLog table which has the following fields:
ActivityLogID - Autonumber (Primary)
EmployeeID - Text (Relates to EmployeeTable)
ActivityType - Text
ActionDate - Date/Time (This is what determines what day the occurance occur)
EndingDate - Date/Time (365 days + Action Date)
DaysOff - Number (Difference)
ReasonCode - Text (Relates to ReasonCode Table - has the points etc.)
Points - Number (Points received)
SickDaysUsed - Number
VacationDayUsed - Number
My question is how to generate a team members perfect attendance by month calculating and keeping a count of previous months until they receive a point? Should I make another table name Perfect attendance and have append and delete queries run each month? Or should I just try and query out the information through my ActivityLog Table?
Thank you