Sudha
05-28-2001, 08:59 AM
I have two subforms(not nested) on a main form. Both the subforms have a total field(=sum[(fieldname)]). Now I want the sum of these two totals on my main form. Please help.
Sudha
Sudha
|
View Full Version : total of two subforms Sudha 05-28-2001, 08:59 AM I have two subforms(not nested) on a main form. Both the subforms have a total field(=sum[(fieldname)]). Now I want the sum of these two totals on my main form. Please help. Sudha KevinM 05-28-2001, 12:09 PM =[Forms]![MainForm]![Subform1].[Form]![Field1]+[Forms]![MainForm]![Subform2].[Form]![Field2] Sudha 05-28-2001, 08:39 PM Thank you it worked! Sudha |