SELECT Sum(MyField) AS Total FROM MyView INTO CURSOR curSum
lnTotal = lnTotal + curSum.Total
USE IN curSum

HTH

---

>I have a view that I use to input data in a grid. In the amount field, valid method, I want to recalculate the totals by cumulating the amount in each record of the current view. The problem is that it makes me loose my current pointer.
>
>How can I achieve this?