Sub Reports

[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

 

[Marshall Barton]

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.

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.

 

[Melinda]

I will give that a shot and if I have trouble I will post back. Thanks for
your advice.