Attendance Tracking

[Tia Gathings]

Hi Guys,
I am new to the world of Access. I've figured a few things out through trial and error, but I've hit a wall. I am trying to create an attendance tracking report for work. I can make the Qry show what I need it to for the most part. Occurrences with reasons, any warnings received with reasons, both based on employee and their manager. I also need it to count occurrences, when it gets to 3 give a verbal, 5 give a written, 9 give a final. All within a 90 day period. Is there a way to automatically do that or would we still need to enter in the warnings?
Any help would be appreciated.
Thanks,
Tia

 

[Minty]

You can count things on a rolling 90 days by simply entering criteria against your attendance record date, something like >Date()-90 should do the trick.

You should also have a record of when a warning has been issued, within your attendance records. You can then use that record as stepping point for your date calculations.