sorting and grouping a report

[steve goodrich]

I have a report set up that displays names, depts and addresses. I have it
sorted by dept. The report runs continuous. How do I set it so that it
will insert a page break when one dept ends and another one starts.

The dept field is on the report header.
many thanks

 

[Jeff Boyce]

Steve

If you want the report to have a page break after each department, you'll
need to group by department. Use both a group header and group footer, and
in the properties of the group footer, have it start on a new page after the
section (group section, department) changes.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[steve goodrich]

many thanks jeff