Access Report Problem

[Luke K]

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

=Sum([sellprice])+Sum(Reports![rptSubRptCustomItems]![ItemPrice])

but that does not work, I get the #Name? error.