Nz Function Question

[Guest]

I hope someone can help me.
I have this formula in the control source of a textbox on a mainform's footer
My 2 subforms default view is set to Continuous
=Nz(Transfers1_subform!SumOfQty1,0)+Nz(Transfers2_subform!SumOfQty2,0)

This formula works when both subforms have data otherwise text value = #Error

Can some please help me or tell me where I can go to get help

Thanks Mike

 

[Guest]

Use the nnz()function shown here:
http://www.mvps.org/access/forms/frm0022.htm

Steve