Yep

I've tested this and it all seems to be working tickidyboo!

Thanks again BB



>>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
>
>
>
>

>SELECT Route, Class, SType, Family,;
>       SUM(PrevPassngers) AS PrevPassngers,;
>       SUM(PrevMult)      AS PrevMult,;
>       SUM(PrevNumTrips)  AS PrevNumTrips,;
>       SUM(CurrPassengers)AS CurrPassengers,;
>       MAX(CurrMult)      AS CurrMult,;
>       SUM(CurrNumTrips)  AS CurrNumTrips;
>FROM MyTable;
>GROUP BY Route, Class, SType, Family;
>INTO CURSOR crsTest
>BROSE NORMAL
>