>>
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
Cetin, looking at your reference I wondered if there a solution to the problem than we can't do selects on buffered data other than calculating initial values and adding/subtracting changes? That sure would be useful.
Alex