We help IT Professionals succeed at work.

Compare Time from two tables

nibirkhan
nibirkhan asked
on
694 Views
Last Modified: 2008-02-04
I have two tables, TBL_JobTrack and TBL_TimeTrack. When employee comes in the morning they sing in and the data goes to TBL_TimeTrack and later they start job and data goes to TBL_JobTrack.

How do I get a report or a query to get a daily comparison who started job after how many minutes they signed in. Also my table structures are not the same but they both have a [StartTime] field which contains the Date and time.

Any idea?
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.