Hi all,
I'v recently finished a VB to Access invoice system and its working fine, except for one small problem. I want the total of a field added up, so I used the aggregate function Sum. However, I want it to appear at the bottom of the page but as far as I can tell nothing is evaluated in the Page Footer. I have to either put it in the Report Detail section or in Report Footer, but then, it doesnt appear at the bottom.
I then tried to base the field on a query which would do the adding up for me, but im not sure how to base the field on a query that the report is not based on.
So there is two ways to resolve this:
1) Is there a way to evaluate aggregate functions or anything else in the Page Footer section of a report
or
2) How do I base a field on a query other then the query that the report is based on?
Any ideas are welcome :)
EDIT:
The field that I want to populate will be the sum of a field on the report + the sum of a field of a subreport that is on the report. I tried using
but that does not work, I get the #Name? error.Code:=Sum([sellprice])+Sum(Reports![rptSubRptCustomItems]![ItemPrice])
