Page Break

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that prints a list of members and one of the fields is a
yes/no field for those below the age of 18. I have already created the
sorting by those below 18 but what I want to do is to force a page break the
moment it hits the first record of below 18 but I ended up with a page break
for EVERY record of below 18. In other words, I want to print a list of
members where below18=no and then for those where below18=yes, to begin on a
fresh page. How do I do that? THanks.
ck
 
Are you storing the age value from a point in time or are you storing the
date of birth?

You can set a grouping level in your report to an expression like:
=[Age Expression]<18
You can force a page before or after to suit your needs.
 
The field is just a yes/no field. So I want to group all those with "no"
first and then when it comes to those with "yes" to print on a new page. Can
that be done?
ck

Duane Hookom said:
Are you storing the age value from a point in time or are you storing the
date of birth?

You can set a grouping level in your report to an expression like:
=[Age Expression]<18
You can force a page before or after to suit your needs.

--
Duane Hookom
MS Access MVP


CK said:
I have a report that prints a list of members and one of the fields is a
yes/no field for those below the age of 18. I have already created the
sorting by those below 18 but what I want to do is to force a page break
the
moment it hits the first record of below 18 but I ended up with a page
break
for EVERY record of below 18. In other words, I want to print a list of
members where below18=no and then for those where below18=yes, to begin on
a
fresh page. How do I do that? THanks.
ck
Click to expand...
Click to expand...
 
Back
Top