Combining information from two records in a query

[bravo6]

I am trying to take information from two different records and combine them to one record. See below:


Record Key Depart Return
2351 12JUN 13JUN
2351 15JUN 16JUN

These are two different segements of the same trip.

I want to end up with Depart Return
12JUN 16Jun

this gives me the actual trip duration from 12-16JUN.

Can anyone help?

Thanks

 

[PHV]

A starting point (SQL code):
SELECT [record Key], Min(Depart), Max(Return)
FROM yourTable
GROUP BY [record Key]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886