G
Guest
I have a form with payment amount, charge and balance for lessons. Lessons
are usually paid in groups of four. I would like to calculate a balance in a
form where a person could pay, then if 0 were typed in for the 3 subsequent
payments, the balance would still be deducted. (Or if a negative balance
were reached, that would be calculated as well). I have this in a report
using the NZ function and running sum property to "over group", then sorted
by account. However I don't have this option in a query or a form!
I'm sorry if this question has already been answered; as far as I could
find none of the solutions already posted quite matched my needs.
Any help would be appreciated,
Tarnia
are usually paid in groups of four. I would like to calculate a balance in a
form where a person could pay, then if 0 were typed in for the 3 subsequent
payments, the balance would still be deducted. (Or if a negative balance
were reached, that would be calculated as well). I have this in a report
using the NZ function and running sum property to "over group", then sorted
by account. However I don't have this option in a query or a form!
I'm sorry if this question has already been answered; as far as I could
find none of the solutions already posted quite matched my needs.
Any help would be appreciated,
Tarnia