S
Secret Squirrel
I'm tracking employees attendance based on the following criteria:
No shows
Tardy
Left Early
I have a table called tblTimeClock where I import data from my time clock
system with the actual times the employee punches in and out.
I also have a table called tblBusinessHours where I store the current
business hours. I have custom records in this table that are directly linked
to a specifc employee because they may have special hours or they may be part
time employees.
What happens is every night after hours I run a macro that imports the data
into the tblTimeClock and then matches the shiftID to the tblBusinessHours to
lookup the business hours for that employee. Then it calculates if they are
late or leave early. If this is the case then it appends a record to the
tblAttendance. If there was no record in the tblTimeClock for an employee
then it creates a record in the tblAttendance as a No Show.
The problem I'm having is if the employee is working part time 3 days a week
then it will automatically create a record for them for the other 2 days. I
don't want it to do this for my part time employees. Any ideas on how I can
prevent it from creating records if they are part timers? I was thinking I
could create 5 true/false fields in my tblBusinessHours, one for each day of
the week. Then have it some how look up to see which values are true and if
there is no record for one of those days in the tblTimeClock then have it
append a record to the tblAttendance. But if any of these fields are false
then do not have it append a record. I know this sounds confusing. I'm trying
to explain it the best I can. I just need to find a way to control which
records get appended if they are part timers. I figured I'd post here to see
if anyone has any advice.
Any ideas?
No shows
Tardy
Left Early
I have a table called tblTimeClock where I import data from my time clock
system with the actual times the employee punches in and out.
I also have a table called tblBusinessHours where I store the current
business hours. I have custom records in this table that are directly linked
to a specifc employee because they may have special hours or they may be part
time employees.
What happens is every night after hours I run a macro that imports the data
into the tblTimeClock and then matches the shiftID to the tblBusinessHours to
lookup the business hours for that employee. Then it calculates if they are
late or leave early. If this is the case then it appends a record to the
tblAttendance. If there was no record in the tblTimeClock for an employee
then it creates a record in the tblAttendance as a No Show.
The problem I'm having is if the employee is working part time 3 days a week
then it will automatically create a record for them for the other 2 days. I
don't want it to do this for my part time employees. Any ideas on how I can
prevent it from creating records if they are part timers? I was thinking I
could create 5 true/false fields in my tblBusinessHours, one for each day of
the week. Then have it some how look up to see which values are true and if
there is no record for one of those days in the tblTimeClock then have it
append a record to the tblAttendance. But if any of these fields are false
then do not have it append a record. I know this sounds confusing. I'm trying
to explain it the best I can. I just need to find a way to control which
records get appended if they are part timers. I figured I'd post here to see
if anyone has any advice.
Any ideas?