>>>

>>>select left(cmonth(Date),3) as MonthName, sum(weight) as WeightTotal, sum(cash) as CashTotal ;
>>>group by 1 into cursor curTotal
>>>

>>
>>What about different years? His data seems to have more than one year involved.
>
>Stupid me, of course I forgot about it.
>
>

>select year(date) as Year, left(cmonth(Date),3) as MonthName, sum(weight) as WeightTotal, sum(cash) as CashTotal ;
>group by 1,2  into cursor curTotal

Sorry, but I'm going to chime in. Not stupid at all, there was a flaw in the problem statement (specs). The example as given seemed to indicate accumulations by month only without regard to years. The original source data had multiple years which normally would initiate a request for a clarification of the specification. (Lotta words to say... not dumb, reasonable assumption IMO).