All,
I am strugling with a problem. I have a flight table with departure and arrival times, each record is a follow up of the previous record (I'll illustrate it below). For a calculation I need the arrival time of the first leg and the departure time of the second leg, but I don't know how I can create a query that tells to use the times from one and an other record.
Leg Departure Location Arrival Location Departure Time Arrival Time 1 A B 12:00 12:30 2 B C 12:35 12:50 3 C D 12:59 13:15 4 D A 13:45 14:00
I want to calculate the waiting times, so on B it should say 5 min, C, 15 min, D 30 min.
I tried some small queries to determine the next leg and with this to find the departure time, but this didn't work. Hope you have some ideas!