Form Calculations

[Guest]

I have a form that has a child and grandchild subforms.

Form= Customer
Subform=Company
Sub-Subform=Products

The idea is that each customer might have one or more companies, each of
which have a variety of products.

At the bottom of Products is a Subtotal of all the product costs.

I want to display the grand total for all the companies that a customer may
have.
So basically, I want Sum(Sum([Price])) but that doesn't work. Is there a
way to do this? Thanks.

 

[Michel Walsh]

Use a

= DSum("price", "TableNameHere",
"CustomerID=FORMS!FormNameHere!ControlNameWithTheCustomerIDHere")



if the table (or a saved query) can identify the prices given a customerId.



Hoping it may help,
Vanderghast, Access MVP