'Finding the sum of subreport passed values in the main report in ms Access
I have a main report for orders and a subreport for payment installments for each order. I have been able to pass the values from the subreports to the main report using in a new textfield
IIf([rptPayments].[Report].[HasData],Nz([rptPayments].[Report].[txtTotalPayments],0),0)
I am having trouble with summing these values passed from the subreport so I can have total for all payments in the main report footer
Solution 1:[1]
One way to do it is to look for the Running sum property of the field and choose either of its options(Over Group), or(Over All)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Sola Oshinowo |