By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,071 Members | 1,196 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,071 IT Pros & Developers. It's quick & easy.

Clocking in time problem

P: 1
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)
Feb 2 '08 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
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:
tblYourTableName
....
Employee FK(tblEmployees)
dteTimeIn Date/Time
dteTimeOut DateTime

Regards,
Fish
Feb 2 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.