I'm trying to change the sort order for a report. The report shows people working different shifts of the day and is based on a join table called 'shift_positions'. This table has a field named shift_type which would be one of day, night, or detail. I have a sub-summary based on this field and the report works fine. However, it sorts alphabetically - day, detail, night - and I'd like it to be day, night, detail. How would I go about this?

TIA

Define a custom value list and use it for sorting:

http://www.filemaker.com/help/html/find_sort.5.21.html#1038201

Thank-you comment,

works perfectly