SELECTSUM(value) AS sum_value FROM mytable ;
GROUPBY ordnum ;
INTOCURSOR crsTotal
>I'd like to know if I can use a SQL command to accomplish the same thing that would result for a command like: > >TOTAL FIELD value ON ordnum TO tempfile. > >Any suggestions? > >Thanks,