Dual Sort

Can you not just do...
"ORDER BY [ProgressFieldName] ASC, [AssignedName] ASC"
If this will do just change it on the TableList screen In ASPrunner

and select it to order 1st by 'ProgressFieldName' then by 'AssignedName'
or just add the code direct to
output/include/yourproject_variables.asp
gstOrderBy=""
replace with

gstrOrderBy="ORDER BY [ProgressFieldName] ASC, [AssignedName] ASC"
Michael

What I was meaning was that lines with status as "In Progress" would sort 1 way, which fits with what you noted. And I have it set so that status sorts first so all "In Progress - Assigned" lines are grouped separately. The catch is they want the second 'ordered by' to change when the status is changed. Specifically, "In Progress" jobs will order by the status field then Zip Code Zone. When The Staus is changed to "In Progress - Assigned", the 'ordered by' will change to status then assigned driver. This is what I meant by dual sort. They want to 'ordered by' criteria, based on the designation 1 a field. Does that clarify?

I think you can add a calculated field to your query which will hold assigned name when status="In Progress - Assigned" and another value where status field has different value. Then you can sort by this calculated field.