Hi,
I am trying to design a sort of timesheet system using excel and acess, where my employees will enter their hours worked on particular jobs into the excel spreadsheet, and then update that info into my centralized database. The database will be split into two tables, payhours and jobhours. How many hours each employee worked that week will go into payhours along with their name, and the hours worked on each job will go into the job hours section.
My problem is I want the database to be able to see if anyone has entered hours for that job for the week, and if not create a new tuple for that job. If someone has already put in hours for it, I want the database to add the additional hours to that job number.
Example:
Bob Smith worked 10 hours on job3 and 12 hours on job4
John Jones worked 8 hours on job2 and 8 hours on job3
Payhours
Bob Smith | 22 hours
John Jones | 16 hours
Jobhours
Job2 | 8 hours
Job3 | 18 hours (8 + 10)
Job4 | 12 hours
This is a fairly huge job for me and so any help at all will be greatly appreciated, please reply if something is not clear.
Thank you
Alex White
Bookmarks