total in textbox

[micfly]

Trying to show the total of these textbox controls.



I tried this:

=[FinRes]+[Gap]+[Vsc1]+[Vsc2]+[OtherF&I]

in the control source of the textbox control but that only works if there are numbers in all the fields.

So I try this:

=IIf(IsNull([FinRes]+[Gap]+[Vsc1]+[Vsc2]+[OtherF&I]),0,([FinRes]+[Gap]+[Vsc1]+[Vsc2]+[OtherF&I]))

But same thing.
How do I get the total to work if some of the fields are empty?

Sorry, just learning Access, thanks for any help.

[RuralGuy]

Use the Nz() function.
=Nz([FinRes],0)+Nz([Gap],0)+Nz([Vsc1],0)+Nz([Vsc2],0)+Nz([OtherF&I],0)

[micfly]

Thanks for answering; I was beginning to wonder if anyone was on here helping. I finally figured it out and that's exactly what I did. I can't believe something so simple is so hard in Access (compared to Excel - which is what I am used to). Thanks again.

[RuralGuy]

Excellent! You always learn more when you solve it yourself anyway.