
Situation 1: I have a box that calculates TotalBalance using this formula: =[InitialBalance]+[Commission]-Forms!Orders.Payment!Text8
to break this down, i have an initial balance, a commission and payments. InitialBalance and Commission is entered in the OrderForm. Payment is a continuous subform which runs this formula in the footer section: =Sum([Payments]). Therefore when payment received at a later date the user goes back to the order and enters the payment.
Problem 1: Everything works great when there is a payment, but when there isn't - i don't get a value for my TotalBalance. Same problem occurs in the Report that runs a similar quiery.
Situation 2: In the payment subform i have few fields PDate, Payment, and PaidBy.
Problem 2: How do i go about ensuring that the user will have not blank lines there or payments such as $0.
Thanks to all!