Adding fields when one field is blank

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

Guest

I have three fields. Rent and arrears and latefee. When arrears or rent fee
is blank, I don't get a total. This is what I did in the text field I
created.

=[rent] + [arrears] + [latefee].

I use Access 2000 and don't have a clue about programming. I don't want to
take the extra stop of putting a zero in arrears and latefee to I get a total.

Thanks in advance for any help.
 
=NZ([rent],0)+NZ([arrears],0)+NZ([latefee],0)

See NZ Function in the help file for details.
 
Your suggestion worked perfectly. Thanks.
Brendan Reynolds said:
=NZ([rent],0)+NZ([arrears],0)+NZ([latefee],0)

See NZ Function in the help file for details.

--
Brendan Reynolds


diros said:
I have three fields. Rent and arrears and latefee. When arrears or rent
fee
is blank, I don't get a total. This is what I did in the text field I
created.

=[rent] + [arrears] + [latefee].

I use Access 2000 and don't have a clue about programming. I don't want
to
take the extra stop of putting a zero in arrears and latefee to I get a
total.

Thanks in advance for any help.
Click to expand...
Click to expand...
 
Back
Top