SUM totals of a recordset

[Marc Vanzegbroeck]

Hi,

Is it posible to sum the total of field in a recordset?
Now If I wanted the sum I run a query with sum(myfield) as total and it work.

But now I want to show a recordset, and the the client can put a filter on it , and then I want to sum the totals of the filter records.

[nageswaragunupudi]

But now I want to show a recordset, and the the client can put a filter on it , and then I want to sum the totals of the filter records.

We need to calculate the sum manually.
If you are using xbrowse, oBrw:MakeTotals() does this work for us.
This is what I do too

[Marc Vanzegbroeck]

So, I do do have to make a loop in the filtered recordset, and sum() the fields?

[nageswaragunupudi]

Yes, but instead of your doing it, xbrowse does it by itself.
Are you not using xbrowse's maketotals facility?

[Marc Vanzegbroeck]

No, I do it manualy, because it's a sum of a calculation of 2 fields....

Thanks