"Fred" wrote:

> Maybe someone else can take a good guess, but  I think that we would need to
> understand precisely what you mean by "bring in" , "Double Sized", "second
> report", "First report", "down the screen" (in the context that reports go on
> paper" plus exactly what you are trying to do  in order to understand your
> post.  
>
> A couple more thoughts: Most reports are (vertically) several feet long, and
> are chopped into the paper size by the printer driver, based on the printer
> and the paper size settings.  Page break  is normally used to force a new
> page, independent of the paper size.

> Sorry, Fred, for not explaining myself very well.
>
> At the present I have 2 separate reports that print to Legal size paper.  I
> would like to combine the two reports into 1 report, so that a Printer that
> will print Double size can be instructed to print as Front and back in the
> same action.
>
> When I copy and paste the contents of the 2nd report into the first report,
> the text overlaps. in part, the first page.
>
> I hope this is clearer and thanks
>
>
> "Fred" wrote:
>
>> Maybe someone else can take a good guess, but  I think that we would need to
>> understand precisely what you mean by "bring in" , "Double Sized", "second
>> report", "First report", "down the screen" (in the context that reports go on
>> paper" plus exactly what you are trying to do  in order to understand your
>> post.  
>>
>> A couple more thoughts: Most reports are (vertically) several feet long, and
>> are chopped into the paper size by the printer driver, based on the printer
>> and the paper size settings.  Page break  is normally used to force a new
>> page, independent of the paper size.

"John Spencer MVP" wrote:

> If that is the only problem, you could try adding a page break between the
> items you want on the first page and the items you want on the second page.
>
> There is a page break control on the tool bar.
>
> There are other ways to handle this situation (two that come to mind)
> -- adding a group section and putting one "report" in the group header and the
> other "report" in the detail.  The group would have to be based on the same
> sorting criteria as the detail section. YOu would need to set the page breaks
> for the group appropriately.
> -- using your two reports as sub-reports on another report and inserting a
> break between the sub-reports.
>
> John Spencer
> Access MVP 2002-2005, 2007-2009
> The Hilltop Institute
> University of Maryland Baltimore County
>
> Roger Bell wrote:
> > Sorry, Fred, for not explaining myself very well.
> >
> > At the present I have 2 separate reports that print to Legal size paper.  I
> > would like to combine the two reports into 1 report, so that a Printer that
> > will print Double size can be instructed to print as Front and back in the
> > same action.
> >
> > When I copy and paste the contents of the 2nd report into the first report,
> > the text overlaps. in part, the first page.
> >
> > I hope this is clearer and thanks
> >
> >
> > "Fred" wrote:
> >
> >> Maybe someone else can take a good guess, but  I think that we would need to
> >> understand precisely what you mean by "bring in" , "Double Sized", "second
> >> report", "First report", "down the screen" (in the context that reports go on
> >> paper" plus exactly what you are trying to do  in order to understand your
> >> post.  
> >>
> >> A couple more thoughts: Most reports are (vertically) several feet long, and
> >> are chopped into the paper size by the printer driver, based on the printer
> >> and the paper size settings.  Page break  is normally used to force a new
> >> page, independent of the paper size. 
>

> Thanks very much for your help John.  I did the Report and Subreport with the
> page break.  The only problem with that is that the reports are based on a
> Parameter Query and the Criteria now needs to be entered twice.
>
> Is there any way around this?
>
> Thanks again
>
> "John Spencer MVP" wrote:
>
>> If that is the only problem, you could try adding a page break between the
>> items you want on the first page and the items you want on the second page.
>>
>> There is a page break control on the tool bar.
>>
>> There are other ways to handle this situation (two that come to mind)
>> -- adding a group section and putting one "report" in the group header and the
>> other "report" in the detail.  The group would have to be based on the same
>> sorting criteria as the detail section. YOu would need to set the page breaks
>> for the group appropriately.
>> -- using your two reports as sub-reports on another report and inserting a
>> break between the sub-reports.
>>
>> John Spencer
>> Access MVP 2002-2005, 2007-2009
>> The Hilltop Institute
>> University of Maryland Baltimore County
>>
>> Roger Bell wrote:
>>> Sorry, Fred, for not explaining myself very well.
>>>
>>> At the present I have 2 separate reports that print to Legal size paper.  I
>>> would like to combine the two reports into 1 report, so that a Printer that
>>> will print Double size can be instructed to print as Front and back in the
>>> same action.
>>>
>>> When I copy and paste the contents of the 2nd report into the first report,
>>> the text overlaps. in part, the first page.
>>>
>>> I hope this is clearer and thanks
>>>
>>>
>>> "Fred" wrote:
>>>
>>>> Maybe someone else can take a good guess, but  I think that we would need to
>>>> understand precisely what you mean by "bring in" , "Double Sized", "second
>>>> report", "First report", "down the screen" (in the context that reports go on
>>>> paper" plus exactly what you are trying to do  in order to understand your
>>>> post.  
>>>>
>>>> A couple more thoughts: Most reports are (vertically) several feet long, and
>>>> are chopped into the paper size by the printer driver, based on the printer
>>>> and the paper size settings.  Page break  is normally used to force a new
>>>> page, independent of the paper size.

"John Spencer" <spen***@chpdm.umbc> wrote in message
news:%23T9DvGD$JHA.4560@TK2MSFTNGP03.phx.gbl...
> Best way is to use a control on a form and call the report from the form.
> That way you can enter a value in the form and it will be available for
> both reports.
>
> In a query, you can refer to the control with
>   Forms![Name of Your Form]![Name of your Control]
> and use that in place of the parameter.
>
> '====================================================
>  John Spencer
>  Access MVP 2002-2005, 2007-2009
>  The Hilltop Institute
>  University of Maryland Baltimore County
> '====================================================
>
>
> Roger Bell wrote:
>> Thanks very much for your help John.  I did the Report and Subreport with
>> the page break.  The only problem with that is that the reports are based
>> on a Parameter Query and the Criteria now needs to be entered twice.
>>
>> Is there any way around this?
>>
>> Thanks again
>>
>> "John Spencer MVP" wrote:
>>
>>> If that is the only problem, you could try adding a page break between
>>> the items you want on the first page and the items you want on the
>>> second page.
>>>
>>> There is a page break control on the tool bar.
>>>
>>> There are other ways to handle this situation (two that come to mind)
>>> -- adding a group section and putting one "report" in the group header
>>> and the other "report" in the detail.  The group would have to be based
>>> on the same sorting criteria as the detail section. YOu would need to
>>> set the page breaks for the group appropriately.
>>> -- using your two reports as sub-reports on another report and inserting
>>> a break between the sub-reports.
>>>
>>> John Spencer
>>> Access MVP 2002-2005, 2007-2009
>>> The Hilltop Institute
>>> University of Maryland Baltimore County
>>>
>>> Roger Bell wrote:
>>>> Sorry, Fred, for not explaining myself very well.
>>>>
>>>> At the present I have 2 separate reports that print to Legal size
>>>> paper.  I would like to combine the two reports into 1 report, so that
>>>> a Printer that will print Double size can be instructed to print as
>>>> Front and back in the same action.
>>>>
>>>> When I copy and paste the contents of the 2nd report into the first
>>>> report, the text overlaps. in part, the first page.

>>>>
>>>> I hope this is clearer and thanks
>>>>
>>>>
>>>> "Fred" wrote:
>>>>
>>>>> Maybe someone else can take a good guess, but  I think that we would
>>>>> need to understand precisely what you mean by "bring in" , "Double
>>>>> Sized", "second report", "First report", "down the screen" (in the
>>>>> context that reports go on paper" plus exactly what you are trying to
>>>>> do  in order to understand your post.
>>>>> A couple more thoughts: Most reports are (vertically) several feet
>>>>> long, and are chopped into the paper size by the printer driver, based
>>>>> on the printer and the paper size settings.  Page break  is normally
>>>>> used to force a new page, independent of the paper size.
>