Conditional Page Breaks

  • Thread starter Thread starter Jim K.
  • Start date Start date
J

Jim K.

I'm sure this is an old problem.

I have a series of records. The key field I want to print
by is structured : A01 thru Ann, B01 thru Bnn etc. I
would like to start the B's on a new page when the A's end.

This will follow with a new page for "C" and so on.

Any pointers, direction to a ms suport item, book or site
will be most appreciated.

Thanks

Jim K.
Old programmer who can do this in 4 other languages but
can't figure out how to do it in Access.
 
While in the report design mode, go to sorting and
grouping and group the report by:
=Left(YourKeyField,1)
and select group header
Than go to the header band in the report and set new page
before to yes.
This will make each group to start on a new page.
Hope this helps.
Fons
 
That got me there Fons. Many thanks. Jim K.
-----Original Message-----
While in the report design mode, go to sorting and
grouping and group the report by:
=Left(YourKeyField,1)
and select group header
Than go to the header band in the report and set new page
before to yes.
This will make each group to start on a new page.
Hope this helps.
Fons
.
Click to expand...
 
Back
Top