<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.<br />
<br />
Any idea?
</div>
</div>


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?

Compare Time from two tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.