asked on

How can I create a subreport inside of a report in Access 2003

I have a report that show data and I would like to create a subreport inside this at the end with more data from the report on the top.

ASKER CERTIFIED SOLUTION

momo4kids

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Sheils

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

<create a subreport inside this at the end with more data from the report on the top.>
?
Can you explain what this means, please?

A subreport is designed to show Parent/Child (One-To-many) relationships.
Ex:
Customer-->Orders
Or
Employee-->Tasks

So, using a specific example from your data, can you explain what you are trying to achieve?
(A subreport may not even be needed...)

;-)

JeffCoachman

Jeffrey Coachman

For example, if all you need are totals, you can do this quite easily in the Report Footer.

Drop a Textbox on the Report Footer and set the controlsource property to:
=Sum([YourField])

So if you had a column of Prices and you wanted a total of them at the bottom of the report you would drop a Textbox on the Report Footer, and set the controlsource property to:
=Sum([Price])

;-)

JeffCoachman

iscivanomar

ASKER

Thank you, I did not do this before but it seems really sample too.