Select ;
    SUM( Miles ) AS nTotMiles, SUM( Units ) AS nTotUnits ;
    FROM table ;
    INTO CURSOR qTotAmounts


lnTotAmounts = qTotAmounts = table.nTotMiles
<\PRE>

etc.

HTH