RE: Start and End times - same date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


If this is all there is to your data then it is simple, but if you have more
than two entries per day then you have to sequentially number them first to
do it.

In design view put your table in the space above the grid area twice.
Access will add a sufix of '_1' to the second instance.

Join the two table on the date field by clicking and dragging.

Pull down all fields from the first table.

Pull down the 'Time In' field from the second.

In the Criteria row under second table 'Time In' field type this --
<[FirstTable].[Time Out]

This will pull all records that have 'Time In' before 'Time Out'.

For datasets that have multiple entries per day you also need criteria on
the numbering to make sure you are comparing the following record. That
would be [FirstTable].[Number]+1 compared to [SecondTable].[Number].

"vianda via AccessMonster.com" wrote:

I need to audit a form checking the times for the same date. I need to create
a report showing this info.

Date Time In Time Out
4/12 10:15 AM 11:15 AM
4/12 12:30 AM 1:00 PM

4/13 9:00 AM 9:30 AM
4/13 9:15 AM 10:15 AM overlap

4/14 10:00 AM 10:30 AM
4/14 10:30 AM 11:00 AM no travel time

I'm having a hard time to figure out how to substract the second time in from
the first time out. There are in different columns and rows. If somebody
can help i will appreciate it.

Viviana

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200907/1


.

Relevant Pages

  • Re: Access Table Sorting/Query Last Function
    ... I've put in a number of test entries to ensure it works, ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... I've done this so that I can pull the last entered ...
    (microsoft.public.access.tablesdbdesign)
  • Re: putting database results in a 5x1 table
    ... Eddie Biscomb wrote: ... > I have a db of tens of thousands of entries. ... It's not too hard to pull ... > set and display above, then loop through the result set until I'm done? ...
    (comp.lang.php)
  • RE: How to print select months from worksheet
    ... Use a helper column to achieve this. ... only those entries will print out. ... I need to know if there is a way to pull and print only the most ... recent 3 months worth of data from this sheet. ...
    (microsoft.public.excel.misc)
  • putting db results in a 5 x 1 table
    ... It's not too hard to pull all the entries and build a table that displays them one at a time, but in my case, that will be a huge waste of space. ... How can I tell php to take five records from my result set and display above, then loop through the result set until I'm done? ...
    (php.general)
  • putting database results in a 5x1 table
    ... It's not too hard to pull all the entries and build a table that displays them one at a time, but in my case, that will be a huge waste of space. ... How can I tell php to take five records from my result set and display above, then loop through the result set until I'm done? ...
    (comp.lang.php)