T
Ted Hall
I am having a problem trying to have an access database
track employees sick time. On July 1 every employee is
given 40 hours of sick time. They keep that time forever
or until they use it. For example employee 1 has 40
hours on july 1, 2002. Prior to july 1, 2003 he uses 16
hours. On july 1, 2003 he gets 40 more hours and keeps
the unused hours from the previous year for a total of 64
hours remaining. Right now I have an employee table that
lists all employee information.
[employees]
employeesid
lastname
firstname
MI
DOH
EMP#
Department
I have a second table [occurences] that lists what an
employee did every day they were scheduled to work.
[occurences]
employeesid
date
job function code
hours
The job function codes are 2 character abreviations for
the work class. IE: PA for put away, AS for Absent Sick.
After all of the employees information has been entered
for the day I want to be able to generate a report for
each employee that shows how much sick time is left. My
biggest problem is that we have over 300 employees, and
entering several lines of work data for each employee
every day, the table is getting large. Since we don't
need this data for longer than a year, each year I go in
and clean out old data in the [occurence] table. On
January 1, 2004 I will remove data older than Jan 1,
2003. Does anyone have an Idea how I can track sick
time? Several people enter occurence data into the
database everyday, and I would like to do this with as
little manual work as possible. Thanks.
..
track employees sick time. On July 1 every employee is
given 40 hours of sick time. They keep that time forever
or until they use it. For example employee 1 has 40
hours on july 1, 2002. Prior to july 1, 2003 he uses 16
hours. On july 1, 2003 he gets 40 more hours and keeps
the unused hours from the previous year for a total of 64
hours remaining. Right now I have an employee table that
lists all employee information.
[employees]
employeesid
lastname
firstname
MI
DOH
EMP#
Department
I have a second table [occurences] that lists what an
employee did every day they were scheduled to work.
[occurences]
employeesid
date
job function code
hours
The job function codes are 2 character abreviations for
the work class. IE: PA for put away, AS for Absent Sick.
After all of the employees information has been entered
for the day I want to be able to generate a report for
each employee that shows how much sick time is left. My
biggest problem is that we have over 300 employees, and
entering several lines of work data for each employee
every day, the table is getting large. Since we don't
need this data for longer than a year, each year I go in
and clean out old data in the [occurence] table. On
January 1, 2004 I will remove data older than Jan 1,
2003. Does anyone have an Idea how I can track sick
time? Several people enter occurence data into the
database everyday, and I would like to do this with as
little manual work as possible. Thanks.
..