I have a database that is tracking racers and their results in bike races.
Riders earn points based on their finish time as a % of the fastest finish time in their gender and ability category....
I have a select query that pulls the riders name, gender, ability, and finish time.
I have a calculated field [SORT] that adds their gender and ability.
I am trying to write a function that would determine the lowest finish time in each unique SORT category.....
I have used Dmin... but have hit a road block... no matter how I approach it, DMin simply returns the lowest finish time... it neglects the fact that the riders are in categories... which doesnt help.
Can DMin be written in a way that would post the minimum result for each unique value in another field?
ie.
If I have mens expert, mens sport, and mens beginner, as categories and then have several riders in each of those classes... I need to see the lowest mens sport time displayed next to any rider who is in that category.... as well as the same result for the other categories.
Right now I can get the lowest time overall displayed next to ALL the records.
I am a self taught access user... so I may be missing something obvious.
Any help would be appreciated.
AJ
Riders earn points based on their finish time as a % of the fastest finish time in their gender and ability category....
I have a select query that pulls the riders name, gender, ability, and finish time.
I have a calculated field [SORT] that adds their gender and ability.
I am trying to write a function that would determine the lowest finish time in each unique SORT category.....
I have used Dmin... but have hit a road block... no matter how I approach it, DMin simply returns the lowest finish time... it neglects the fact that the riders are in categories... which doesnt help.
Can DMin be written in a way that would post the minimum result for each unique value in another field?
ie.
If I have mens expert, mens sport, and mens beginner, as categories and then have several riders in each of those classes... I need to see the lowest mens sport time displayed next to any rider who is in that category.... as well as the same result for the other categories.
Right now I can get the lowest time overall displayed next to ALL the records.
I am a self taught access user... so I may be missing something obvious.
Any help would be appreciated.
AJ