I am grouping a report by Trip # which have Legs (not all trips have the same number of legs). I would like to show the Origin of Leg 1 of a trip and the Origin of the last leg of a trip in the Trip # header. Any ideas? Here's what the data looks like (roughly):
Leg 1 CA OR
Leg 2 OR WA
Leg 3 WA CA
I would like the Trip #3583 to read CA to WA (origin of first leg and origin of last leg).
Any help would be greatly appreciated.