Why is it when I try to SUM() on a cursor, I get a result of the first record's data multiplied by reccount(). If I attempt the same thing on a table, the result is correct?

SUM(user.amount) TO xx

If I use a table with 2 records, the first amount = 2 second amount = 3, the answer is 5. If I do the same command on a cursor, the answer is 4. It seems to take the first value it sees as all values.

Any suggestions?

M. Carpio
MIS - Pep Boys