I couldn't get it to work for the problem I was trying to solve. We were accumulating totals for all consumers for a year. I ended up using a fastforward cursor and using variables to accumulate the totals.

The problem I couldn't overcome was if a consumer had more than 3 lines and many of them did.

Thanks for your help.

John

>>Thanks for the reply. This gives me some good ideas for the solution. I'll play around with it.
>>
>
>Hi John,
>
>I would be interested to see your solution to this problem, if possible.