HI guys... ive' got a queary here.. but i cant understand how to mod it to make it work correctly..

Select
*
From
lap_data
Where
lap_data.ld_lap_tm != ''
Order By
lap_data.ld_lap_tm


now the lapdata table is contains a bunch of records what are the output from a timing system..

the table contains about 260 records which relate to about 40 individual riders and i need to sort it in the order of the fasted (lowest timed lap) rider , the above works for that but i need to only return the row for each riders fastest lap, i try and group using the riders race number but i only get the fastest laps from the first instance of the riders in the table....

i know this as the number of the lap comes back at always 1 in the group but i know that some of the riders had better times on the 2nd and third lap....

please contact me if you need more info and data...
thanks for anyone's help in advance



pad