AnsweredAssumed Answered

Sort one field twice

Question asked by fredtsui on Sep 13, 2018
Latest reply on Sep 13, 2018 by philmodjunk

Hello all -

 

I have a DB that tracks results of horse jumping team competition. I track the results of each rider, the penalty incurred, and time taken. Each team has two riders. I would like to have a report that orders the teams first by the team with the fewest penalties, then by the fastest combined times. I have a layout that has a sub-summary by Team, then by start order, then lastly by Team again. So the report shows:

 

Team1

     Rider1     start_order     Penalty     Time

     Rider2     start_order     Penalty     Time

                                        Total Pens.  Total Time

Team2

     Rider1     start_order     Penalty     Time

     Rider2     start_order     Penalty     Time

                                        Total Pens.  Total Time

etc.

 

I can get the report to sort on Team with a reorder based on Summary field of total penalties. But I can't figure out how to get it to do another sort based on summary field total time?

 

Thanks,

Outcomes