I have a cursor with records as follows:

Route  Class  SType  Family  PrevPassngers PrevMult PrevNumTrips CurrPassengers CurrMult  CurrNumTrips
0588          D      G                386      1.75       676.79
0588          D      G                                                     147      1.00        147.00
0588          D      G                                                     194      1.00        194.00
0588          D      G                                                     313      1.00        213.00
0011          C      B                 33      1.75        57.86
0011          C      B                                                       1      1.00          1.00
0016          C      E                675      1.75      1183.51  
0016          C      E                                                       3      1.00          3.00
0016          C      E                                                      17      1.00         17.00
0016          C      E                                                      10      1.00         10.00
...

and need to condense/combine them into 1 rec for each Route/ClassStype/Family combo, i.e.

Route  Class  SType  Family  PrevPassngers PrevMult PrevNumTrips CurrPassengers CurrMult  CurrNumTrips
0588          D      G                386      1.75       676.79           554      1.00        554.00
0011          C      B                 33      1.75        57.86             1      1.00          1.00
0016          C      E                675      1.75      1183.51            30      1.00         30.00

Is there a quick SQLish way of doing this without having to loop and append and accumulate and all that?
There could just as easily be many recs to the left (prev) side to one or few on the right (curr)

'ppreciate it

Terry