Summing in Text Boxes

[bhujanga]

I am trying to show the sum of several bound controls on my form in another unbound control. The problem I'm having is that not all of the controls always have values in them and the text box that sums them won't show anything unless there is a value in all of them. I'm just using the format "=[Control1]+[Control2]+[Control3]..."
Is there a syntax I can use that will treat nulls like zeroes?

Thanks

 

[PHV]

Perhaps something like this ?
=Nz([Control1],0)+Nz([Control2],0)+Nz([Control3],0)...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bhujanga]

Yep, that does the trick. Thank you very much.