myaccess2000
Technical User
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
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