I have a table with records representing different activities related to hauling loads and the start/stop times of each. Activities include actual travel time & stops that occur (such as for fuel, breakdown, etc.)
I want to calculate the actual driving time by subtracting the stop time from the travel time.
The records are related only by the driver and the Date/Time. So, to subtract the correct stops, I need to selct the stops that have the same driver & fall within the start & stop times of the travel.
I'm not sure of the best way to attack this. Thanks for the help.