Thanks Dorin
I did end up doing that. But I am still curious why that works when SQL against the view ignores any changes made.
Nick Mason
>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