Hello genen17821!
I believe you can use the DateDiff function in Access to compile a clean calculation of the hours worked for each, then calculate totals thereafter:
(1) You may need to have a check for when users are clocking out
(2) Checkboxes can be used to fire time clocked in and out
(3) Using DateDiff against TimeClockedIn, TimeClockedOut, as one example will give you number of hours, minutes, seconds, etc...
This can be pulled into your form. You can pin each Checkbox on your form, namely TimeClockedIn and TimeClockedOut to a Before or AfterUpdate type of event procedure to record a date either is checked.
Please stay here for a better idea on this. And if you have not previously searched here, I'd suggest you do, examples are surely available to fit your purpose.
Good luck with the project!
Dököll
Thanks for the information - will work with the datediff function as that will help. However, the main problem that I am experiencing is the best way to structure the data. I would like to leave all the data in a table and then access it, calculate on it, etc, through queries (as opposed to code) to make things easiest. The question is, how to structure that table.
For example, is it best to just have have a tblClockTime that gets recorded each time the employee clocks in our out with a tblClockActionID that denotes if its clock in or clock out? Or would it be better to have a tblClockTimeIN field and a tblClockTimeOUT field and then work with the differences there?
I think that I will work with the second option for a while pending any further updates from yourself and or other members. Thanks!
Gene