Page Break after Change

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.
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top