I am attempting to track employee sick time using a Microsoft Access Database. The purpose of the tracking is to provide reports indicating the number of sick days and the number of sick turn-ins for each employee. (A turn-in is an unbroken sequence of days out sick. The weekend, or a holiday is not considered a break in the sequence. For example, if a person is out sick from Wednesday through Tuesday, their sick days are listed as Wednesday, Thursday, Friday, Monday and Tuesday. This is reported as five sick days and one turn-in. Whereas, if someone is sick on Monday, Tuesday, Thursday and Friday, it would be reported as four sick days and two turn-ins. Coming to work on Wednesday caused a break in the sequence and makes the Thursday sick day the start of a new turn-in).
I have a table with the fields "Name" and "Sick Day Date" (the other fields are departmental information) Each sick day creates a new record.
I can easily calculate the number of sick days per employee, but I am at loss on how to calculate the number of Turn-ins.
Can anyone help me?
I have a table with the fields "Name" and "Sick Day Date" (the other fields are departmental information) Each sick day creates a new record.
I can easily calculate the number of sick days per employee, but I am at loss on how to calculate the number of Turn-ins.
Can anyone help me?
