Summing a textbox

[myaccess2000]

Hi,

I have problem in summing a textbox. The textbox control source contains "=IIf(IsNull([sum_debit]),Sum([debit_amount]),Sum([debit_amount])+[sum_debit])". Due to the condition in the IIF, i could not do it in the query. I have to do the summing in the report.

Would appreciate if someone out there can help me. Thanx!

Regards

 

[cmmrfrds]

Stick a 0 in when null and it should sum up okay.

"=Sum(nz([sum_debit],0)),Sum([debit_amount]),Sum([debit_amount])+[sum_debit])".