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.