Is there a way I can get a calculated difference between the same field in two different records without using the records primary ID field?
I'm looking at cycle times where I may have between 9 to 15 cycles per day per vehicle. I want to see the time span between the start of each cycle or the time span between the finish of each cycle. This may include up to 6 different vehicles doing the same function each day.
At present I sort a query by the (Truck ID) and the (Start of Cycle Time). But I haven't been able to figure out a calculated field to get me a (Time Difference Between Consecutive Cycle Start Time By The Same Truck)
The data is entered through a manifest, so I need to sort the table before I can review the data.
Appreciate any insight.
I'm looking at cycle times where I may have between 9 to 15 cycles per day per vehicle. I want to see the time span between the start of each cycle or the time span between the finish of each cycle. This may include up to 6 different vehicles doing the same function each day.
At present I sort a query by the (Truck ID) and the (Start of Cycle Time). But I haven't been able to figure out a calculated field to get me a (Time Difference Between Consecutive Cycle Start Time By The Same Truck)
The data is entered through a manifest, so I need to sort the table before I can review the data.
Appreciate any insight.
