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.
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.