How do I page break after a grouping field?

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

Guest

I'm working on a report in Access 2003 that should have a header, a grouping
field which is an office name, a list of employees, and then a footer. The
default behavior of access though is to keep cycling through the data until
it runs out.

What we're trying to do is generate a series of letters, one per office,
asking the directors to verify the information for each of their employees.
I would like to be able to write a footer and then a page break every time
the grouping field changes, but I haven't been able to figure out how. Help!

-Jesse
 
In the toolbox one of the controls available is a page break. Grab it and
drag it into your footer.

Rick B
 
Didn't work. The page prints the footer and breaks fine after that with or
without the page break control, but each page has multiple grouping fields,
and I'm trying to limit it to only one.
 
Puttting a page break in the group footer should cause the page to break
each time the group changes. Did you put it at the very bottom of the group
footer?
 
Oooooh. GROUP footer!

I didn't even know there was such a thing. Thanks a ton - it works now.
 
Back
Top