You can save the recno() into a local variable, execute a SUM command and then GO TO record number saved into variabile.
LOCAL lnRecno
lnRecno = RECNO()
SUM ...
...
GOTO lnRecno
>Hi
>
>I have a view displayed on a grid.
>
>The user can amend values on the grid updating the view.
>
>I then want to add up one of the columns in the view but when I select the sum of one of the columns it doesn't reflect the changes made on the grid.
>
>Whats the best way to ensure I am adding up what the user can see.
>
>Nick Mason