These are all awesome ideas. Now I have so many choices that I can't make up my mind which one to go with.
Pretty much this is what I was thinking at the begining, but I got hanged up on the idea of doing it w/one query.

thanks a lot guys.


>How about:
>
>

>CALCULATE SUM (R1), SUM (R2), ... TO ARRAY aColSums
>lnTotal = 0
>FOR X = 1 TO ALEN (aColSums, 1)
>    lnTotal = aColSums [X] + lnTotal
>ENDFOR
>

>
>With 30 fields, you may run into a limit issue, but this can be resolved by breaking into multiple runs.
>
> Jay