>There was a thread a couple weeks ago about counts and sums in 3 or 4 level parent-child relations, which finally decided you must do each level separately.

I'll look that thread up. Thanks.

>Jody, you'll probably need to SELECT 3 and 4 together, then 2 & the 3-4 cursor and finally the 1 and 2-3-4 cursor.

That's what I suspected; but I was getting so close to getting
what I want I thought I may be overlooking something obvious.

I can get the totals for 1 record - but I couldn't figure out how to generate the list.