Time difference from two records

Timoty

Registered User.
Local time
Today, 04:16
Joined
Jul 29, 2003
Messages
105
I have two records in a table/query. Time1 and time2. I want to calculate the difference between the time2 of the first record and the time1 of the next record. Can this be done on a line in a query? If not can it be done in a form and sent back to a table?

Biggest question....if so how?

I have calculated this from within the same record but never from two different records.

Thanks again in advance.
Love this place :D
 
Last edited:

Users who are viewing this thread

Back
Top Bottom