Finally, we are getting a proper description with some rules to determine the sort order.
I'm not sure you can do this in one query, I think you will need to load the runners into a recordset, then loop through them and add them to another recordset, adding the heat numbers based on the number...