>

>SELECT FirstName
>       FROM (SELECT TOP 10 Event.RO_No,
>                           MAX(Ro.FirstName)   AS FirstName,
>                           Min(Event.DateTime) AS LastUpdate
>                    FROM Event
>             INNER JOIN RO ON Event.RO_No=RO.RO_No
>             GROUP BY Event.RO_No
>             ORDER BY MIN(Event.Datetime)) Temp
>

Right, this was so simple. I got so into those formulas since a few days that I didn't even thing about that one.

Thanks