Calculated field #error when no value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our database tracks our students tuition paid. Each payment is recorded
under a subform and then subtracted from the total tuition and shows a
balance owing. When there are no payments made and the total tuition is
still owing the Balance Owing field shows #error as well as the Tuition Paid
shows #error. This error does not show if there has been payments made.
 
I believe you are attempting a calculation with what may be a Null value.
Convert potential Nulls to zero with the Nz() function:

=Nz([MyPossiblyNullValue])*Nz([MyOtherPossiblyNullValue])

Sprinks
 
Back
Top