Creating a page break at a change in an item

  • Thread starter Thread starter PaulHilgeman
  • Start date Start date
P

PaulHilgeman

I have a report that is a tabular report, based on a query.

The query contains a number of things, including installer.

The report currently opens as a multi-page list , with page breaks when
it runs out of space. I would like to change this so that it inserts a
page break at every change in installer.

How would I go about doing this, it seems as though it would be a
fairly common thing.

Thanks,
Paul
 
I have a report that is a tabular report, based on a query.

The query contains a number of things, including installer.

The report currently opens as a multi-page list , with page breaks when
it runs out of space. I would like to change this so that it inserts a
page break at every change in installer.

How would I go about doing this, it seems as though it would be a
fairly common thing.

Thanks,
Paul
Click to expand...

In design view, click on View + Sorting and Grouping.
Group the report by [Installer]. Set the Page Header to Yes.
Save the changes.
Move the [Installer] control up into the Page Header section.
Then set the Page Header Force New Page property to Before Section.
 
fredg said:
I have a report that is a tabular report, based on a query.

The query contains a number of things, including installer.

The report currently opens as a multi-page list , with page breaks when
it runs out of space. I would like to change this so that it inserts a
page break at every change in installer.

How would I go about doing this, it seems as though it would be a
fairly common thing.

Thanks,
Paul
Click to expand...

In design view, click on View + Sorting and Grouping.
Group the report by [Installer]. Set the Page Header to Yes.
Save the changes.
Move the [Installer] control up into the Page Header section.
Then set the Page Header Force New Page property to Before Section.
Click to expand...


What Fred said, except he meant to say Group Header instead
of page header.
 
fredg said:
I have a report that is a tabular report, based on a query.

The query contains a number of things, including installer.

The report currently opens as a multi-page list , with page breaks when
it runs out of space. I would like to change this so that it inserts a
page break at every change in installer.

How would I go about doing this, it seems as though it would be a
fairly common thing.

Thanks,
Paul
Click to expand...

In design view, click on View + Sorting and Grouping.
Group the report by [Installer]. Set the Page Header to Yes.
Save the changes.
Move the [Installer] control up into the Page Header section.
Then set the Page Header Force New Page property to Before Section.
Click to expand...

What Fred said, except he meant to say Group Header instead
of page header.
Click to expand...

Thanks for the correction, Marsh.
I guess I was just being more efficient.
Group has 5 characters.. Page has only 4. :-)
 
Thanks guys!!!

These forums are great. I hope to be as good as you guys are at this
someday and be as much of an aid to newbies like myself.

The power of Access is pretty amazing!!

-Paul
 
Back
Top