Page Break

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CK - 05 Jun 2005 10:54 GMT

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

Reply to this Message

Duane Hookom - 05 Jun 2005 13:52 GMT

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.

Signature

Duane Hookom
MS Access MVP

>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
[quoted text clipped - 7 lines]
> fresh page. How do I do that? THanks.
> ck

Reply to this Message

CK - 07 Jun 2005 16:39 GMT

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

> Are you storing the age value from a point in time or are you storing the
> date of birth?
[quoted text clipped - 14 lines]
> > fresh page. How do I do that? THanks.
> > ck

Reply to this Message

Xed - 07 Jun 2005 17:03 GMT

As Duane says, just group on the Yes/No field and either in the grou
header, set the page break property to "Before Section", or in th
group footer (whichever you're using), set the page break property t
"After Section".

Xe

--
Xe

Reply to this Message