ADDING Not showing results

[keiath]

Hi this probably a simple one cant seem to see the problem



I have a unbound textbox that adds up results of returned data ie:- =text386+text443+text461 this adds and displays the total fine when there is a number in each field but if one of them is displaying nothing it then doesnt give a result,

Can anyone tell me how to fix this

Thanks in Advance

[ItsMe]

Maybe the nz() function?

nz(me.text443.value) + nz(me.text461.value)

[keiath]

That doesn't seem to work when i save it does this =Nz([me].[text384].[Value])+Nz([me].[text448].[Value])+Nz([me].[text466].[Value]) in the Expression Builder

and displays #Name? in the box as a return result

[ssanfu]

Try

=Nz([text384],0) + Nz([text448],0) + Nz([text466],0)


This says if [text384] is NULL, use 0 (zero).

[June7]

Can't use Me qualifier in ControlSource expression, that is a VBA feature. Also, Value is default property of data controls so it is not necessary to type it.

Consider giving controls used in expressions more meaningful names.

[keiath]

Thank you this works