select sum(Amount) from gridsTable into array arrSum

But this only works when you do not have table buffered changes in the grid's RecordSource < s >. CALCULATE or SUM TO will give reliable results regardless of whether or not you have buffered changes.

Of course, you still have to remember to restore the record pointer when you are finished doing the sums < s >.