Calculation on a Form

[Guest]

I have a form in which I have four text boxes: (among other things)

[Charges] [Payments] [Payroll] [Balance]

All the calculations work fine except for the [balance]. Here's the
expression for balance: =[chargetot]-[paytot]-[payroll]
Correct Example: 5,000 - 2,000 - 500 = 1500

As long as each field has a value in it, the balance is correct but if the
paytot or payroll fields are zero then it doesn't calculate the balance. It
just displays a #error in the balance field.
Wrong Example 5,000 - 2000 - 0 = #error
Should be 5000 - 2000 - 0 = 3000

Thanks
Stonewall

 

[fredg]

I have a form in which I have four text boxes: (among other things)

[Charges] [Payments] [Payroll] [Balance]

All the calculations work fine except for the [balance]. Here's the
expression for balance: =[chargetot]-[paytot]-[payroll]
Correct Example: 5,000 - 2,000 - 500 = 1500

As long as each field has a value in it, the balance is correct but if the
paytot or payroll fields are zero then it doesn't calculate the balance. It
just displays a #error in the balance field.
Wrong Example 5,000 - 2000 - 0 = #error
Should be 5000 - 2000 - 0 = 3000

Thanks
Stonewall

Look up the Nz function in VBA help.

=Nz([chargetot],0) - Nz([paytot],0) - Nz([payroll],0)