Patrick O'Dea
asked on
Form to show Sum of detail lines
See attached.
Click form frmMainBig.
This shows a single customer (tblCustomers) who is buying 3 products (tblQuoteDetails - see the green bits).
Specifically, note the "line value" in green.
Now look at the orange field at the bottom of the subform.
I want the orange to show the sum of the "line values".
i.e. the Orange should show the sum of the green "line value"
I have tried various options but am unsure of my approach.
All help appreciated! I hope this is clear.
Database11.zip
Click form frmMainBig.
This shows a single customer (tblCustomers) who is buying 3 products (tblQuoteDetails - see the green bits).
Specifically, note the "line value" in green.
Now look at the orange field at the bottom of the subform.
I want the orange to show the sum of the "line values".
i.e. the Orange should show the sum of the green "line value"
I have tried various options but am unsure of my approach.
All help appreciated! I hope this is clear.
Database11.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Slight correct; the text control in the subform footer needs its controlsource to be:
=Sum([Qty]*([sellprice]*(1 -[Discount Percent])) )
JimD.
=Sum([Qty]*([sellprice]*(1
JimD.
ASKER
perfect !
Thankyou!
Thankyou!
BTW, the text control in the subform can be hidden.
JimD.