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
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
Last edited: