total of two subforms (1 Viewer)

Sudha

Registered User.
Local time
Today, 21:42
Joined
May 1, 2001
Messages
29
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

Registered User.
Local time
Today, 21:42
Joined
Jun 15, 2000
Messages
719
=[Forms]![MainForm]![Subform1].[Form]![Field1]+[Forms]![MainForm]![Subform2].[Form]![Field2]
 

Sudha

Registered User.
Local time
Today, 21:42
Joined
May 1, 2001
Messages
29
Thank you it worked!

Sudha
 

Users who are viewing this thread

Top Bottom