W
WarrenG
I have multiple vehicles that are scheduled to leave at different times. I
would like to have a query that returns for each record, each vehicle ( V1,
V2 and V3)in order of its scheduled departure time (ascending), then repeat
for subsequent dates. The vehicle ID and scheduled departure time are in the
same table. eg if V1 departs at 0900 and 1000 and V2 departs at 0600 0900
and 1200 and V3 departs at 1100, 1300 and 1500, then the result I am after
looks like the following
V1 V2 V3
0900 0600 1100
1000 0900 1300
1200 1500
This then repeats for each day.
I hope someone can help as I am completely stuck on this one!
Regards
Warren
would like to have a query that returns for each record, each vehicle ( V1,
V2 and V3)in order of its scheduled departure time (ascending), then repeat
for subsequent dates. The vehicle ID and scheduled departure time are in the
same table. eg if V1 departs at 0900 and 1000 and V2 departs at 0600 0900
and 1200 and V3 departs at 1100, 1300 and 1500, then the result I am after
looks like the following
V1 V2 V3
0900 0600 1100
1000 0900 1300
1200 1500
This then repeats for each day.
I hope someone can help as I am completely stuck on this one!
Regards
Warren