Print one at a time

[tankerman]

In my db I have a form that assigns task to employees, I made a report with
the same info in it and it works OK but when I print the report I get 2 and
sometimes 3 employees to a page depending on their days task. How do I get
the report to print each employee on it's own page. I'm using 2003

 

[Al Campagna]

tankerman,
You'll need to group on something like EmployeeID,
and in that group footer set the footers ForceNewPage
property to AfterSection.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Tom van Stiphout]

On Fri, 3 Oct 2008 17:06:08 -0700, tankerman

One option would be to create a grouping level per employee, and have
the "Page Break After" property for that level set to True.

-Tom.
Microsoft Access MVP

 

[tankerman]

I am already grouping by EmployeeID, I put a page break after the detail
section in the EmployeeID footer and it works just like I wanted it to.

Thanks for the quick reply