Page Break after Change

  • Thread starter Thread starter Lamar
  • Start date Start date
L

Lamar

In the Page Header section of my report I have text box (txt3yrAppeal) with
that is using the DateAdd function to calculate a date based on a text box
(txtAppealDate) in the Detail section. So it txtAppealDate is 1/10/10 then
txt3yrAppeal is "February 2013".

I want there to be a page break every time txt3yrAppeal changes. So my
dates are grouped together on the same page. So when the date for
txtAppealDate is in the month of January of 2010 then I want txt3yrAppeal to
be "February 2013" with all txtAppealDate(s) of 1/2010 to be listed on a
separate page.

Then when the txtAppealDate(s) change to month of February of 2010 I want
txt3yrAppeal to be "March 2013" with all txtAppealDate(s) of 2/2010 be listed
on a separate page. and so forth.

I creating a report to group files by dates when they can be destroyed.
 
You could attempt to calculate the page breaking value in the sorting and
grouping so you can force a new page before or after in the group header or
footer.
 
Back
Top