>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?
>Thanks
>Eric

selec MyView
lnREcNo = RecNo()

calculate sum(Field1), Sum(Field2), Avg(Field2) to ;
   sum_Field1, sum_field2, avg_Field2

if lnRecno > 0
   go lnRecno
endif

BOb