Employee working hours tracker table design?

[siamandm]

Hello All,
I would like to create a database for tracking the working hours for employees, and I came with this design below, I would like to see your suggestion if it's wrong and what is the correct way to do it?

Excel sample data.jpg

EmployeeWorkingHoursTracker.jpg

regards

[HansV]

Do you have a specific reason for storing the date and time in separate tables? If I were to design such a database I would store them in the same table.

[siamandm]

you mean I need something like this?

EmployeeWorkingHoursTracker2.jpg

[HansV]

Yes, indeed.

[siamandm]

Thank you very much

[siamandm]

Do you have a specific reason for storing the date and time in separate tables? If I were to design such a database I would store them in the same table.

Dear Hans, what if I want to choose the date one time for the employee as shown in this form below :

[HansV]

You could use the Before Insert event of the form:

Code: Select all

Private Sub Form_BeforeInsert(Cancel As Integer) 
    Me.WorkingDate = Me.txtDate
End Sub

where txtDate is the text box in the header. As soon as you start to enter anything in a new record, the date will be filled in.

[siamandm]

thank you very much .. as usual working very good :)