A query delivers somuch data that I can not put all the information on one 
page. Is it possible to create nice and neat multiple page reports?

Thanks for suggestionsand answersto the above question?

Ron

RoBo wrote:

>A query delivers somuch data that I can not put all the information on one 
>page. Is it possible to create nice and neat multiple page reports?


Multiple page reports are the normal, everyday kind of
report.  You must be doing something unusual.  Maybe someone
could make a suggestion if you described the records
returned by your query and how you want the data displayed
in the report.

-- 
Marsh
MVP [MS Access]

Hello Marshall,

What I mean is that the info from one record should be placed om multiple 
pages. I found the pagebreak contril, can I use this to create multiple pages 
for one single record?

Ron

"Marshall Barton" wrote:

> RoBo wrote:
> 
> >A query delivers somuch data that I can not put all the information on one 
> >page. Is it possible to create nice and neat multiple page reports?
> 
> 
> Multiple page reports are the normal, everyday kind of
> report.  You must be doing something unusual.  Maybe someone
> could make a suggestion if you described the records
> returned by your query and how you want the data displayed
> in the report.
> 
> -- 
> Marsh
> MVP [MS Access]
> 

A page break will start a new page in the printed report.
OTOH, Access will automatically spread data over as many
pages as needed, so I suspect you want something other than
what I read in your question.

Maybe, you are really looking for more space to layout the
report design???  If so, each section of a report can be a
maximum of 22 inches, which should be sufficient for two
pages.  If that's still a problem, you could try making any
tall controls shorter and set their CanGrow property to Yes.
-- 
Marsh
MVP [MS Access]


RoBo wrote:
>What I mean is that the info from one record should be placed om multiple 
>pages. I found the pagebreak contril, can I use this to create multiple pages 
>for one single record?
>
>
>> RoBo wrote:
>> >A query delivers somuch data that I can not put all the information on one 
>> >page. Is it possible to create nice and neat multiple page reports?
>> 
>
>"Marshall Barton" wrote:
>> Multiple page reports are the normal, everyday kind of
>> report.  You must be doing something unusual.  Maybe someone
>> could make a suggestion if you described the records
>> returned by your query and how you want the data displayed
>> in the report.