1 report with multiple queries?

G

George

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
 
A

Allen Browne

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

George

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

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

George

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
 
A

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
 
G

George

Champion - thanks heaps

Allen Browne said:
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
Click to expand...
 
Top