MS_Access_Amature
Registered User.
- Local time
- Yesterday, 22:54
- Joined
- Nov 10, 2010
- Messages
- 56
I have 2 tables:
TimeSheet Table
Employees Table
The Employee Table is for when an employee clocks in and clocks out just for that day.
The TimeSheet Table saves all the data (hours an employee worked) so when i make a report you can go back to whatever specific day you want to go back to.
In the form when they click clock in, that time saves in the employees table in the clock in field. Then when they click clock out, that time saves in the employees table in the clock out field. And that's it for that table.
When you save the employee table i want that time worked that day to be added up and saved in the TimeSheet table in the TotalTime Field.
How can i do this?
TimeSheet Table
Employees Table
The Employee Table is for when an employee clocks in and clocks out just for that day.
The TimeSheet Table saves all the data (hours an employee worked) so when i make a report you can go back to whatever specific day you want to go back to.
In the form when they click clock in, that time saves in the employees table in the clock in field. Then when they click clock out, that time saves in the employees table in the clock out field. And that's it for that table.
When you save the employee table i want that time worked that day to be added up and saved in the TimeSheet table in the TotalTime Field.
How can i do this?