>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 >.

Hiya Marcia,
How are you doing.
Honestly I was lazy not to include any further explanation :)
IMHO still SQL is the way to go :
Message #574935
Cetin