Difference between 2 time fields.

  • Thread starter Thread starter Blux
  • Start date Start date
B

Blux

I need to calculate the difference between the "start
time field" of the current and the "stop time field" of
the previous record. Any help would be appreciated.

Thanks
 
This can be done using a subquery that returns the Max(StopTime) from the
same table where the StopTime is less than the StartTime of the current
record.

There are lots of postings regarding subqueries. If you need specific help,
come back with specific field and table names as well as sample records and
desired output.
 
Back
Top