If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Attendance
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? |
Thread Tools | |
Display Modes | |
|
|