Change Sort mid-script?

[lunamuna]

Does anyone know of a way to determine (then change) sort order mid-script?

Is there some way of determining whether a sort is in ascending or descending order? All that Status(CurrentSortStatus) does is say whether it's sorted or not.

Any thoughts?

-Heather

[Vaughan]

I guess you could create a script that compared the value of a field in the first and last record, and work it out from there in combination with the Status(CurrentSortStatus) function.