Adding fields when one field is blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

diros - 22 Oct 2005 22:04 GMT

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.

Reply to this Message

Brendan Reynolds - 22 Oct 2005 22:14 GMT

=NZ([rent],0)+NZ([arrears],0)+NZ([latefee],0)

See NZ Function in the help file for details.

Signature

Brendan Reynolds

>I have three fields. Rent and arrears and latefee. When arrears or rent
>fee
[quoted text clipped - 9 lines]
>
> Thanks in advance for any help.

Reply to this Message

diros - 22 Oct 2005 23:09 GMT

Your suggestion worked perfectly. Thanks.

> =NZ([rent],0)+NZ([arrears],0)+NZ([latefee],0)
>
[quoted text clipped - 13 lines]
> >
> > Thanks in advance for any help.

Reply to this Message