Page Breaks

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

I have a report that is linked to a query. At present the
information is there in the report that I want but the
problem is that is all runs continually. How do I put a
page break so that when a new Club starts it starts on a
new page and then the members for that Club go on the same
page??
 
I have a report that is linked to a query. At present the
information is there in the report that I want but the
problem is that is all runs continually. How do I put a
page break so that when a new Club starts it starts on a
new page and then the members for that Club go on the same
page??
Click to expand...

In Report design view, Click on
View + Sorting and Grouping
Enter the [Club] field in the upper left box, then sort ascending or
descending, then in the lower panel choose Group Header Yes.

In design view, then right-click in the Group header field and display
the property sheet.
On the property sheet's Format tab set the Force New Page property to
Before Section.

Place the Club Name field control in the group header.
Place the member names etc. in the Detail section.
 
-----Original Message-----
I have a report that is linked to a query. At present the
information is there in the report that I want but the
problem is that is all runs continually. How do I put a
page break so that when a new Club starts it starts on a
new page and then the members for that Club go on the same
page??
Click to expand...

In Report design view, Click on
View + Sorting and Grouping
Enter the [Club] field in the upper left box, then sort ascending or
descending, then in the lower panel choose Group Header Yes.

In design view, then right-click in the Group header field and display
the property sheet.
On the property sheet's Format tab set the Force New Page property to
Before Section.

Place the Club Name field control in the group header.
Place the member names etc. in the Detail section.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Fred,

Thank you heaps you are a legend. This had me stumped for
ages, I was beginning to confuse myself....lol

Once again thanks heaps
Amanda
 
Back
Top