Sammy,

As Vlad mentioned, if your cursor is buffered, you should use SUM. Beware that this moves the record pointer. If the cursor is not buffered, it's probably easier to do something like this:

SELECT SUM(nAmount) FROM MyCursor INTO ARRAY laTotal

IF _TALLY > 0
lnTotal = laTotal[1]
ELSE
lnTotal = 0
ENDIF

<From cursor or grid?
if cursor won't there be a conflict when a try to open and sum from cursor hhoked to grid?
if from grid how ?>>

Daniel