C
Cpierswim
I'm a swim coach and I have a huge database of times. I'm trying to get the
database to display the best time of each swimmer in order from fastest to
slowest. Here are the column's in my table
Table: Swims - a table of individual swims for a swimmer over a year. Each
swimmer can have hundreds of swims
-ID_Number - The Numeric key identifier for each swim
-Swimmer_ID - The identifier for the swimmer - there are many duplicates
-Name - The swimmer's name
-Team - The swimmer's team
-LSC - The swimmer's state (I'm only ranking swimmers in a certain state at
this point)
-Age - The swimmer's age on date of swim
-Sex - The swimmer's gender
-Birthday - The swimmer's birthday
-Distance - The length of the swim
-Stroke - The type of swim (freestyle, backstroke...)
-Date_Of_Swim - The day this swim was swum
-Time - The time of the swim
-Course_Code - The type of pool the swim was swum in (Long course, short
course)
-Meet_ID - the meet identifier that the swim was swum in
I want to create a query that will have the following properties
LSC='OH', Age= Less or equal to 10, Sex='M', Distance='50', Stroke='Free',
Course_Code='Long'
I know how to create a query that will give me this, but it lists every
single swim that a swimmer swam that falls into this category. I only want
the Record displayed that is each swimmer's best time ( min([Time]) )
So what is created is a list ranked from fastest to slowest of all the
Swimmer's best times in this event (set of properties).
Suggestions? Requets for clarifications? Please help.
Cpierswim
database to display the best time of each swimmer in order from fastest to
slowest. Here are the column's in my table
Table: Swims - a table of individual swims for a swimmer over a year. Each
swimmer can have hundreds of swims
-ID_Number - The Numeric key identifier for each swim
-Swimmer_ID - The identifier for the swimmer - there are many duplicates
-Name - The swimmer's name
-Team - The swimmer's team
-LSC - The swimmer's state (I'm only ranking swimmers in a certain state at
this point)
-Age - The swimmer's age on date of swim
-Sex - The swimmer's gender
-Birthday - The swimmer's birthday
-Distance - The length of the swim
-Stroke - The type of swim (freestyle, backstroke...)
-Date_Of_Swim - The day this swim was swum
-Time - The time of the swim
-Course_Code - The type of pool the swim was swum in (Long course, short
course)
-Meet_ID - the meet identifier that the swim was swum in
I want to create a query that will have the following properties
LSC='OH', Age= Less or equal to 10, Sex='M', Distance='50', Stroke='Free',
Course_Code='Long'
I know how to create a query that will give me this, but it lists every
single swim that a swimmer swam that falls into this category. I only want
the Record displayed that is each swimmer's best time ( min([Time]) )
So what is created is a list ranked from fastest to slowest of all the
Swimmer's best times in this event (set of properties).
Suggestions? Requets for clarifications? Please help.
Cpierswim