Cannot have multiple page report?

[Mike]

Hi I'm trying to print a report based on updated queried data from an
existing table. The report itself and layout is about 4 pages long and I'm
having issues fitting all four pages of text onto a four page report. The
report only allows me 2 full pages and three quarters of the 3rd page and no
more. Is there an option that I'm missing to expand the report?

 

[Duane Hookom]

You have found the limit to the height of any one section of a report. You
can use subreports or simple create additional "detail" sections. To do this,
add a lowest sorting and grouping level on the primary key field(s) of your
report's record source. Set this section to display a group footer (or
header). This basically extends your detail section.

 

[Mike]

Hi Duane! Thanks for the response and the help. This now makes sense as to
why the report wasnt moving any further down. However I'm not all that savy
with Access and I apolgize ahead of time. If possible could you tell me in
lame terms how to do this?


Michael

 

[Duane Hookom]

There must be some field in your report that is unique/common to your detail
section. Let's assume this field is [UniqueID]. Open the sorting and grouping
dialog and add this field as the last field/expression in the sorting levels.
You can then set the level to display the group header and/or footer. Choose
to display one or both of these. You will now have 1 or 2 more sections that
will extend either the top or bottom of your detail section.