myaccess2000
Technical User
Hi
i have a problem in calculating the grand total. I have a textbox that calculate the subtotal. the textbox name is "sum_of_debit", but the control source, i have entered an expression "=IIf(IsNull([sum_credit]),Sum([credit_amount]),Sum([credit_amount])+[sum_credit])". Hence i need to sum up everything in the "sum_of_debit". instead it prompt me to enter value for it.
So can someone help me...??
Regards
Irene
i have a problem in calculating the grand total. I have a textbox that calculate the subtotal. the textbox name is "sum_of_debit", but the control source, i have entered an expression "=IIf(IsNull([sum_credit]),Sum([credit_amount]),Sum([credit_amount])+[sum_credit])". Hence i need to sum up everything in the "sum_of_debit". instead it prompt me to enter value for it.
So can someone help me...??
Regards
Irene