I have a form that has a Control [SourceVol](number) and then a subform that has another control [SupplyVol](number).
First is for goods picked up. One pickup only. Second is goods delivered (multiple deliveries)
Now on my report The Report Footer Field =Sum([SourceVol]) calculates the total incorrectly. It counts the number SourceVol for every entry in the SupplyVol. Ive tried a report with a subreport but only became more confused than ever.
The report has Report header for Title, Page Header for Labels, Header for Main form Fields, Detail for subform fields
and the Calculated fields in the Report Footer
Any clues anyone please