>>You could use parameterized table-buffered view as Grid.Recordsource. Then you use CALCULATE SUM... from Grid.Column.Text.InteractiveChange event, assuming that you will restore record pointer.
>Edward,
>
>I haven't tested this, but if you are using a view can't you just run another aggregating SELECT against the view to get column sums? You wouldn't have to save/restore record pointers that way.
>
The problem here is that Select-SQL will go to the underlying table ignoring interactive changes (no tableupdated yet) in grid.
Edward Pikman
Independent Consultant