Medal Tally (1 Viewer)

Joined
Mar 23, 2022
Messages
45
Hi everyone,

I have uploaded on DummyDatabase wherein there are two Queries. One for Best Player and one for Champion Team

Now I am exporting the result of the above queries to Ms. Excel and compile it manually.


But I want to pick up only the Top Team from each Group so that I can generate the report in the following format
1653644048268.png


and also to pick up only the Best Athlete from each Group so that I can generate the the report in the following format

1653644088502.png
 

Attachments

see the 4 new Queries.
the reports are based on Query1 and Query2.
view the reports in Print Preview.
 

Attachments

Last edited:
see the 4 new Queries.
the reports are based on Query1 and Query2.
view the reports in Print Preview.
Thank you very much.

There is one more point I want to make is that if there is a tie the report will show more than one best player.
How do I increase the weight of the best player.

In practice if there is a tie in the best player we consult the Scoring Point Table provided by the International Athletics Federation based on the timing and distance secured by each player and after that we determine the Best Player.

In the instance how do we add more weight to the Best Player after determination from the Scoring Point Table.

I also don't want to count the medals secured in the Relay Race "4 x 100M" & "4 x 400M" as these are Team Events. These Medals will be counted for Champion Team but they will not be counted for the Best Player.


sample database uploaded
 

Attachments

last time you have "scoring table" based on the each event and time.
can you post it again.
 
don't you have a "converted" excel file or table?
 
I added my own Weight table.
the fastest time got the Highest score.
i also added Score field to AthleteEvent table.

use qryUpdateAthleteScores to update Score field (i already updated it).
Query4 query will be used in report rptBestAthletes.

this is the fastest i can run the query without using my "code" on the module.
 

Attachments

I added my own Weight table.
the fastest time got the Highest score.
i also added Score field to AthleteEvent table.

use qryUpdateAthleteScores to update Score field (i already updated it).
Query4 query will be used in report rptBestAthletes.

this is the fastest i can run the query without using my "code" on the module.
Thank you so much for helping me.
 
As you will notice in query1, there are 3-way tie for 18 and below category.
We eliminate the rest by comparing their "score", in query4.
 

Users who are viewing this thread

Top Bottom