I’ve been given a brief to build a database (after sometime away from access) to record and monitor staff absences and in the whole it’s a straight forward task however I’ve hit a wall in how to proceed with the actual absence tracking:
The issue I have is:
I have multiple offices eg- Office1, Office2, Office3 etc
And
Multiple absence types eg – Sick1, Sick2, Sick3 etc.
Now Office1 treats Sick1 differently in that after 4 days an action is need and after 8 days another.
Office2 has an action needed after 8 days and after 12 days
Office3 has and action after 10 day.
What I need help with is some pointers in how to tackle the problem, whether it’s through Queries, reports etc – not really sure where to start – any help greatly appreciated.