troubleshooting Question

How to page break Access 2007 reports on changes in data

Avatar of Rance_Hall
Rance_Hall asked on
Microsoft Access
2 Comments1 Solution3876 ViewsLast Modified:
I have a report that prints a list of employees in a particular status.

Ive been asked to add the department (which I did) and then to page break on each change in department.  (which I cant figure out)

The point is to print a list of employees who meet certain criteria on a department specific report to give to the dept supervisors.

Ive set the "keep togther" for departments, but my problem now is short lists, if the list of one department is short enough, the second department list prints on the same page as the first.  How do I fix this?

each department gets their own page, even if there is just one entry on the page.  (its okay to not print departments pages with no qualifying employees.)


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros