View Single Post
  #2 (permalink)  
Old November 15th, 2004, 04:29 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   If you base your results on a query, perhaps passing the athlete's name from a combo box, then you can create the query and and sort the time field in ascending order. Then go to the query's Properties dialog box, and on the line "Top Values" put a "1". You will have to enter 1 and then a space since it will try to autocomplete 100.

   Then when you pass the athlete's name as a parameter, it will only return that athlete's fastest time.


mmcdonal