Sam Summers
Registered User.
- Local time
- Today, 12:13
- Joined
- Sep 17, 2001
- Messages
- 939
Is this possible?
I have a form with a tabbed form with 25 pages of stock. Each one has a total field in the footer and i want to display the total value of all the stock held in the header of the main form.
At the moment i have tried this but i am just getting an error
=Sum([TotalAerosolsSubform].[Form]![Cost]+[TotalBoltsSubform].[Form]![Cost]+[TotalNutsSubform].[Form]![Cost]+[TotalWashersSubform].[Form]![Cost])
I have a form with a tabbed form with 25 pages of stock. Each one has a total field in the footer and i want to display the total value of all the stock held in the header of the main form.
At the moment i have tried this but i am just getting an error
=Sum([TotalAerosolsSubform].[Form]![Cost]+[TotalBoltsSubform].[Form]![Cost]+[TotalNutsSubform].[Form]![Cost]+[TotalWashersSubform].[Form]![Cost])