Sub Reports

  • Thread starter Thread starter Melinda
  • Start date Start date
M

Melinda

I am having trouble with getting totals from the subreports to the main
report. If I have several pages on the subreport it only brings the total
from the last page of the subreport. I have changed the running sum to
over all, but still the totals are not correct. This is a budgetary
database and I am trying to get an overall total of what money they have left
to spend. Any help would be greatly appreciated
 
Melinda said:
I am having trouble with getting totals from the subreports to the main
report. If I have several pages on the subreport it only brings the total
from the last page of the subreport. I have changed the running sum to
over all, but still the totals are not correct. This is a budgetary
database and I am trying to get an overall total of what money they have left
to spend.
Click to expand...


Since a group header/footer can appear many times and there
is no way to specify which instance of a section you are
referrencing, you can not get subtotals from a subreport
into the main report.

The most straightforward approach to presenting a summary
page is to create a Totals type of query that calculates the
subtotals and use the query as the record source for a
simple subreport.
 
Back
Top