I have filtered one recordset to get a total amount of $ in my field "charges" and did the same to get a total in the payments repeated region...

Now i would like to make a basic subbstraction, rest or - operation to get the balance between charges and payments...

any ideas????

You can use the select statement to get the totals of a field for a recordset something like this:

SQL = "SELECT SUM(debits) AS TotalDebits, SUM(credits) AS TotalCredits FROM tbl_accounting"

Then use:

varTotalDebits = RecordSet.Fields.Item("TotalDebits".Value
varTotalCrebits = RecordSet.Fields.Item("TotalCrebits".Value
varBalance = varTotalDebits - varTotalCredits
Response.Write(varBalance)


Regards,



_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

Thank you, it worked perfect, love the simplicity...