That's fantastic, thanks a lot guys.

The only minor things I need to resolve now are how to cater for score’s that are the same. So if 2 players have the same time then they should get the same medal. I couldn't see a way to use sort to resolve this so will I'll have to check each score manually?

The other issue is that I've changed the xml to have 2 score tags per player for some events but not all <record-score-a> and <record-score-b>.
Which lead me to create a record-tag variable but I was having trouble passing this between templates as it's value get's cleared.

Example below:
.
.
.
    <xsl:template match="records">
        <xsl:variable name="tag-name">
            <xsl:choose>
                <xsl:when test="@type = 'Type2'">record-score</xsl:when>
                <xsl:when test="@type = 'Type3'">record-mixed</xsl:when>
                <xsl:otherwise>recordAB</xsl:otherwise>
            </xsl:choose>
        </xsl:variable>
        <xsl:apply-templates select="events/event">
             <xsl:with-param name="record-tag">$tag-name</xsl:with-param>

        </xsl:apply-templates>
    </xsl:template>

    <xsl:template match="events/event">
        <xsl:param name="record-tag"/>

        <xsl:choose>
             <xsl:when test="$record-tag = 'recordAB'">
                 <xsl:apply-templates select="player">
                    <xsl:sort data-type="number" order="{$sortDirection}" select="record-score-a"/>
                </xsl:apply-templates>
                <xsl:apply-templates select="player">
                    <xsl:sort data-type="number" order="{$sortDirection}" select="record-score-b"/>
                </xsl:apply-templates>
            </xsl:when>
            <xsl:otherwise>
                <xsl:apply-templates select="player">
                    <xsl:sort data-type="number" order="{$sortDirection}" select="$record-tag"/>
                </xsl:apply-templates>
            </xsl:otherwise>
        </xsl:choose>
.
.
.

Any further help would be much appreciated.
Ally

Can you show the revised XML? What criteria do you use to decide wheteher to use record-score-a or record-score-b?



--

Joe (Microsoft MVP - XML)

Adding the 2 score tags now means there are 2 medals for each event. So Player 1 would get 2 golds for event 1 and 2 golds for event 2.

Here is an example of the updated xml.

<games xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <records type="Type1">
        <events>
            <event name="event1" score="time">
                <player name="Player1">
                    <record-score-a>10.00</record-score-a>
                    <record-score-b>20.00</record-score-b>
                </player>
                <player name="Player2">
                    <record-score-a>11.00</record-score-a>
                    <record-score-b>22.00</record-score-b>
                </player>
                <player name="Player3">
                    <record-score-a>12.00</record-score-a>
                    <record-score-b>24.00</record-score-b>
                </player>
            </event>
            <event name="event2" score="time">
                <player name="Player1">
                    <record-score-a>10.00</record-score-a>
                    <record-score-b>20.00</record-score-b>
                </player>
                <player name="Player2">
                    <record-score-a>15.00</record-score-a>
                    <record-score-b>30.00</record-score-b>
                </player>
                <player name="Player3">
                    <record-score-a>20.00</record-score-a>
                    <record-score-b>40.00</record-score-b>
                </player>
            </event>
        </events>
    </records>
    <records type="Type2">
        <events>
            <event name="event3" score="points">
                <player name="Player1">
                    <record-score>200</record-score>
                </player>
                <player name="Player2">
                    <record-score>100</record-score>
                </player>
                <player name="Player3">
                    <record-score>50</record-score>
                </player>
            </event>
            <event name="event4" score="points">
                <player name="Player1">
                    <record-score>10</record-score>
                </player>
                <player name="Player2">
                    <record-score>20</record-score>
                </player>
                <player name="Player3">
                    <record-score>5</record-score>
                </player>
            </event>
        </events>
    </records>
</games>

Ally