Bob,
PMFJI, but if you are using buffering, your lnRecNo > 0 will not work if you add any records, the record numbers are negative.
Rex
>>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