Designing a 2-page report in Design View

[Guest]

Hi,

Hopefully this is a simple one...

I am designing a report in Design View. The report is based on a single
(lengthy) record that is designed as a 2-page report. I can't seem to figure
out how to add the second page in design view.

So how do I do this?

Thanks,
David

 

[Allen Browne]

In report design view, choose Sorting And Grouping from the View menu.

In the Sorting And Grouping dialog, choose your Primary Key field.
In the lower pane of the dialog, set Yes for Group Header.
Access adds a new section to the report above the detail section.

Since this is the primary key, this section will appear as a header over
every record. Move the first page of your report up into this section. Set
the sections' Keep Together property to Yes, and the page will break between
the 2 sections.

If you ever need a 3rd page in the future, you can set the field's Group
Footer to Yes as well. If you need more pages, you can choose the primary
key field again on the next line of the dialog, for more header and footer
sections that appear for every record.

David, now we have sorted out your issue, I would suggest that so many
fields in a single record is probably not a normalized design. If you have
any repeating fields (e.g. Week1, Week2, ... or Item1, Item2, ...) it would
be better to create a related table instead of a wide record.

 

[Duane Hookom]

If you set the detail height to about 16-20 inches, that would be about 2
pages.

 

[Marshall Barton]

I am designing a report in Design View. The report is based on a single
(lengthy) record that is designed as a 2-page report. I can't seem to figure
out how to add the second page in design view.

Just insert a Page Break control where you want the second
page to start.