SORTING AND GROUPING

[gambler844]

i HAVE WINDOWS XP AND ACCESS 2003
I print out horse races.
Some races have 6 horses and others have 14.
Each race is identified by race track, date and race number.
The problem I having is If there are 10 horses in a race1 i will print out
9 horses on sheet one [which is ok] then i will print out horse 10 on the
next sheet of paper, but then i will start printing out race 2 on that same
sheet of paper.
What i want to accomplish is every time the race number changes, i will
print that race out on a seperate sheet or sheets of paper. In other wors i
want each race to have its own sheets or sheets of paper.
thanks for any help
ed

 

[Douglas J. Steele]

Both Headers and Footers associated with Grouping objects have a
ForceNewPage property you can set.

 

[gambler844]

How do i set force new page property.
Thanks for helping
ed
--
thanks

Both Headers and Footers associated with Grouping objects have a
ForceNewPage property you can set.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

i HAVE WINDOWS XP AND ACCESS 2003
I print out horse races.
Some races have 6 horses and others have 14.
Each race is identified by race track, date and race number.
The problem I having is If there are 10 horses in a race1 i will print
out
9 horses on sheet one [which is ok] then i will print out horse 10 on the
next sheet of paper, but then i will start printing out race 2 on that
same
sheet of paper.
What i want to accomplish is every time the race number changes, i will
print that race out on a seperate sheet or sheets of paper. In other wors
i
want each race to have its own sheets or sheets of paper.
thanks for any help
ed

 

[gambler844]

Thanks Douglas. I figured it out.
--
thanks

Both Headers and Footers associated with Grouping objects have a
ForceNewPage property you can set.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

i HAVE WINDOWS XP AND ACCESS 2003
I print out horse races.
Some races have 6 horses and others have 14.
Each race is identified by race track, date and race number.
The problem I having is If there are 10 horses in a race1 i will print
out
9 horses on sheet one [which is ok] then i will print out horse 10 on the
next sheet of paper, but then i will start printing out race 2 on that
same
sheet of paper.
What i want to accomplish is every time the race number changes, i will
print that race out on a seperate sheet or sheets of paper. In other wors
i
want each race to have its own sheets or sheets of paper.
thanks for any help
ed