1 report with multiple queries?

[Guest]

Hi,
I want to add at the bottom of the Report another query. Is this possible.
My 2nd report shows an unmatched query which would look ideal on the bottom
of the report.
Thanks
George

 

[Allen Browne]

Add a subreport to the Report Footer section.
The subreport can be based on your unmatched query.

 

[Guest]

Thanks Allen,
I am not sure how to source a sub report for the footer in Design View.

 

[Allen Browne]

Steps:

1. Create a new report based on the unmatched query, and laid out how you
would like it to look. Save. Close.

2. Open the main report in design view.
If you do not see a Report Footer section, go to the View menu, and click:
Report Header/Footer.

3. Drag the report you saved at step 1 into the Report Footer section of
your report.

4. Check the Properties of the subreport control, to make sure there is
nothing in the Link Master Fields and Link Child Fields properties, so that
the subreport shows everything from its source query.

 

[Guest]

Thanks Allen,
This is a great help. One problem i am having now is that the subreport
begins on a new page. Is there a way to make it start at the end of main
report?
George

 

[Allen Browne]

In report design view, click the Report Footer section (grey bar).
In the Format tab of the Properties box, set:
Force New Page None
Keep Together No

 

[Guest]

Champion - thanks heaps

In report design view, click the Report Footer section (grey bar).
In the Format tab of the Properties box, set:
Force New Page None
Keep Together No