Sub Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Melinda - 30 Sep 2008 12:26 GMT

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

Reply to this Message

Marshall Barton - 30 Sep 2008 16:20 GMT

>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Melinda - 30 Sep 2008 17:48 GMT

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

> >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
[quoted text clipped - 12 lines]
> subtotals and use the query as the record source for a
> simple subreport.

Reply to this Message