Medal Tally (1 Viewer)

[amirkharkongor]

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

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

 

[arnelgp]

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

 

[amirkharkongor]

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

 

[arnelgp]

last time you have "scoring table" based on the each event and time.
can you post it again.

 

[amirkharkongor]

last time you have "scoring table" based on the each event and time.
can you post it again.

 

[arnelgp]

don't you have a "converted" excel file or table?

 

[amirkharkongor]

don't you have a "converted" excel file or table?

No I don't have.

 

[arnelgp]

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.

 

[amirkharkongor]

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.

 

[arnelgp]

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.