Question:

I am trying to make an attendance log.

I need it to have a continuous watch over a 365 day period, where if more than 7 sick days were taken by any employee over a 365 day period, a pop up or some kind of message notifies me.

Any and all help would be greatly appreciated.

i am trying to figure it out but kind figure out the logic.

Please if you need more information dont hesitate to ask,