In Access how do I manage Hours per employee per Project per Date.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to track a specific employee's hours on a specific project on a
given date. How do I set up the database to accomplish this task? Later, I
have to export that information to a 'certified pay' report for verification
with the customer. Any ideas? Thank you.......
 
I would set up a table like:
tblEmpProjWork
===============
epwEWPID autonumber Primary Key
epwEmpID link to tblEmployees.empEmpID
epwPrjID link to tblProjects.prjPrjID
epwWorkDate date of work
epwWorkHours number of hours worked (numeric-double)
epwComments
 
Back
Top