SubForm totalling

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

Guest

I cannot get an aggregate Total of $amts on the MainForm and $amts on the
SubForm - if one is a NULL value.
In explanation - I have a $ amt on the MainForm which I need to add to $amts
on the SubForm, and show the total at the bottom of the MainForm.
I have no problem getting the total as long as I have $amts in both the
MainForm and in the SubForm - BUT - if the SubForm is empty (Null) then no
total appears. Interestingly, the total does appear momentarily, but
immediate flicks off into oblivion.
This appears logical to me - as adding a value to a Null gives Null - BUT -
I would like to find a way to achieve the aggregateTotalling, even if the
SubForm is Null.
Appreciate any help.

Glynn
 
Thank you Dennis - This has solved my problem. Thank you again for your
prompt and clear response.
--
Glynn


Dennis said:
[GrandTotal] = Nz([MainformTotal],0) + Nz([SubFormTotal],0)

Glynn said:
I cannot get an aggregate Total of $amts on the MainForm and $amts on the
SubForm - if one is a NULL value.
In explanation - I have a $ amt on the MainForm which I need to add to $amts
on the SubForm, and show the total at the bottom of the MainForm.
I have no problem getting the total as long as I have $amts in both the
MainForm and in the SubForm - BUT - if the SubForm is empty (Null) then no
total appears. Interestingly, the total does appear momentarily, but
immediate flicks off into oblivion.
This appears logical to me - as adding a value to a Null gives Null - BUT -
I would like to find a way to achieve the aggregateTotalling, even if the
SubForm is Null.
Appreciate any help.

Glynn
Click to expand...
Click to expand...
 
Back
Top