I am asking this question to see if what I am looking to do is possible before I waste a lot of time and effort trying to make it work.

I would like to create a scoring application to track the results of a competition. There will be multiple athletes competing and there will be multiple events. Each event will be scored and the athletes will be ranked depending on how they perform compared to the other athletes in that same event. I have created a form for athletes and an event. I can enter the results in the event form that has a lookup for the athlete in the athletes form. I also have a field for the results for that athlete in that event. I would like to create a view that would list the entries in the events table, displaying the athlete with a column displaying the rank of that athlete for that event (1st, 2nd, 3rd, 4th, etc.)

The competition will consist of multiple events that the athletes will compete in. And I need to tally the places each athlete finished for each event into an overall total. The athlete with the lowest total at the end of the day wins.

Is it possible to create such an application? I would imagine a series of functions would need to be created in order to calculate the rank of each athlete's score compared to the other athletes for the same event.

Any guidance or help would be greatly appreciated. I have a month to make this application work.

Thank you,

David