Empty Value

[rml]

I have a form that has four currency fields. I trying to total the fields
with a command buttion.

[total] = [A] + + [C]

My problem is, if one of the fields are empty or blank, the total is empty
or blank. How can I make it add the fields even if one is blank or empty?

Thanks.

 

[Allen Browne]

Use Nz() to substitute a zero for null:
[total] = Nz([A],0) + Nz(,0) + Nz([C],0)

Hopefully this is just an example, and you are not really storing the total
in a field like that.