Nz Function Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top