>>Also.......rather than doing a SCAN/ENDSCAN or DO WHILE, you might also try
>>
>>SUM OrderAmount TO lnTotalOrder FOR Cust_ID = lcCustID
>
>Or, do the seek and then SUM while cus_id = m.lcCustID
You took my say (as my daughters would put it). I'd bet my two cents this would be the fastest... for one cus_id. If I had to do it for the whole table, then I'd surely do a select sum().