Clocking in time problem

[anchamal]

I’m using Ms Access 2003 and I have this problem in the query,

I created two tables named timein and timeout. The first one contains the time field that the employees are coming (timein) to work and the second one contains the field for the time they are leaving (timeout)
My problem is that I don’t know how to connect these two tables in the query to show the results and make the calculations need for the total working time for every employee
(for every table the employee has to give his code)

[FishVal]

Hi, anchamal.

You'd better review your tables design. I would suggest you to store timein and timeout in a single record to facilitate calculations and make it more resistant to possible errors.

Like the following:
tblYourTableNam e
....
Employee FK(tblEmployees )
dteTimeIn Date/Time
dteTimeOut DateTime

Regards,
Fish