Right now in my layout I have a "Sub-summary by STATUS (leading)." STATUS is the field for the values PENDING and PASS. So when I print, I have two nice sections of PENDING and PASS projects. Within those sections, the projects are sorted by date. How can I sort them by another field?--Say Alphabetically by author? AND since there are multiple projects by one author, how do I sort by date after that?

In sum: I'd like to keep my sections of PENDING and PASS, and within those sections sort first by author, then by date submitted.

Any help would be much appreciated! Thanks!

David

Have you tried changing the sort order to Status, Author, Date Submitted?