Calculated field #error when no value

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top