Attendance

I am building a database that has about 700 employees and that I want to
track all attendance records. For example if John Doe were to call in sick
today that would be an attendance point and that point would not be removed
from his attendance until a year from today plus any other days he would miss
from the day he received the point to the day it should be removed. Any
takers on how to go about this?

Hi Fred,

Record in a table the date that an employee was away, with a reason if you
like. Then you would calculate your points accordingly - eg: select count(*)
from tblEmployeeAwayDays where [AwayDate] = (date()-365)

Hope this helps.

Damian.

"Fred" wrote:

I am building a database that has about 700 employees and that I want to
track all attendance records. For example if John Doe were to call in sick
today that would be an attendance point and that point would not be removed
from his attendance until a year from today plus any other days he would miss
from the day he received the point to the day it should be removed. Any
takers on how to go about this?