How to sort in a layout?

[drkwiz]

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

[Vaughan]

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