Tricky Sorting

[stevec]

Hi! Not even sure if this would be a "scripting" issue or not...

Here's my question...is there a way to do a sort within a sort?

Example: I have twenty records to display. Each record has a 'title' field, a 'part' field, a 'status' field, and 6 different 'date' fields (date1, date2, date3 etc).

Is it possible to sort by title, then depending on what the status field says, by the appropriate date field?

i.e. the first 8 sorted records are for the title "Eagles"

The first 3 of those 8 records are status="A", which would need to be sorted by the date2 field...The next 4 records are status="B", which would need to be sorted by the date3 field, etc.

Then the next 3 sorted records are for the title "Owls", etc etc etc.

Does that even make sense? Any help greatly appreciated!!

[Girwin]

Perhaps this might work--

Add a new calculation field called "Sort Date" which results in a date.

The calculation would be:

Case(Status = "A", date2, Status = "B", date3, Status = "C", date4, ... [and so on]

Then, sort the records by:

Title

Status

Sort Date