Difference between 2 time fields.

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
 
D

Duane Hookom

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.
 
Top