var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with Nz function in control source
I am trying to add fields from various subforms. The subfirm field is a calculated field. sum(extended_Price)
I am using =Main_sub1.Form!Text1+Main_sub2.Form!Text2 in the control source for the grand total. I would like to take into account Null and zero entries but i am having trouble with the Nz function.
thanks for your help
Well, all you need to do is wrap each expression that returns an integer in the NZ function.
=NZ(Main_sub1.Form!Text1, 0) + NZ(Main_sub2.Form!Text2, 0)
ur codings are working excelent.
Hi pootle flump,
I tried the code but it returned #Error
I even tried =NZ([Main_sub1].[Form]![Text1],0) which works if Text1 = 0 but not if null. Very confused.
P.S the s/w put the  in the formula above for some reason?