S Sudha Registered User. Local time Today, 01:51 Joined May 1, 2001 Messages 29 May 28, 2001 #1 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
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
K KevinM Registered User. Local time Today, 01:51 Joined Jun 15, 2000 Messages 719 May 28, 2001 #2 =[Forms]![MainForm]![Subform1].[Form]![Field1]+[Forms]![MainForm]![Subform2].[Form]![Field2]
S Sudha Registered User. Local time Today, 01:51 Joined May 1, 2001 Messages 29 May 29, 2001 #3 Thank you it worked! Sudha
