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

P

PS

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.......
 
D

Duane Hookom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top