I have a report - based on a query - that needs to be sorted, first by Department; then by Inspector; then case name in alphabetical order.

I can get the first sort to work OK as well as the second sort on the Inspector. But, I also need a new page break after each Inspector. I have tried a variety of options within the Sorting/Grouping on the report and on the Header properties to no avail. Any ideas?

Do I need to tie the first two fields - Dept. and Inspector - together somehow?

I appeciate any input. Thanks.

Have you tried the force new page properties?

Thank you, Rich. Just when I thought I had tried everything - even that one! Sometimes the second time is a charm - and probably on the right control helps too. I appreciate your help.