What's the trick to get a grand total in the header UPDATED from the sum of all the detail lines entered into the linked detail records. If you have 3 detail records with 100 dollars each, then the header should be updated with the grand total of 300 dollars.
Update header total $ from detail record(s) $ (1 Viewer)
- Thread starter dcavaiani
- Start date
I have the Dsum logic figured out, but not sure how to get just the detail records from the subform calculated into the Main form - for just the matching record numbers:
Trying:
...dsum ..."[recordid]=[Forms!SupplierInvoiceHdr.[recordid].value]"
Trying:
...dsum ..."[recordid]=[Forms!SupplierInvoiceHdr.[recordid].value]"
- Local time
- Today, 07:12
- Joined
- Aug 30, 2003
- Messages
- 36,124
