Search results

It is also to be added that only the allowed combination should appear in both the Combo Box.

I have uploaded one demo Database. In an athletic meet each participant can participate in only two Events (100M, 200M, 400M, 800M, 1500M, 3000M, Long Jump, High Jump, Shot Put(5.00Kg), Discuss (1.5Kg), Javelin (700 gms), 4x100M & 4x400M Relays) An athlete can participate in 2 (two) individual...

Thank you so much for helping me.

No I don't have.

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...

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...

Thank you very much for helping me and again sorry for earlier. I have so much to learn from all of you.

Thanks for taking time to find a solution for me. If possible, can you find out any other way to make this type of query updateable

I also found that even if use the GroupRank Query (Query2) on the Filtered Query (Query1), the results of the Query2 is also not editable. Thanks and Please help me.

Hi, Please see Uploaded Dummy Database I have used your GroupRank Query (Query2) on the Filtered Query (Query1) and it is working fine. I tried to use your GroupRank Query (Query without Filter) directly on the on the Table AthleteEvent, it is also working fine and I am getting my desired...

Thanks. I will try to find out more about it.

Thank you very much. So now I will still have to use the Date/Time Extended Data Type available in Access 2021

I am using Date/Time Extended Data Type in office 2021 and i am finding it difficult to compare or convert the time to text/strings. Can I use normal date time data type for sports timing format as "0:00:09.46"

I have a final score as follows BIbNo AthleteName Event Timing ScoringPoint 042 DILCHANG N SANGMA 100m 0:00:09.46 eg. 1400 046 ANIMA ARENGH 100m 0:00:09.47 311 TWINSTAR LYNGDOH 100m 0:00:09.48 084 JOYTIFUL NARLONG 100m 0:00:09.49 046 ANIMA ARENGH 200m 0:00:18.90 049 CHANAKAM...

I am really sorry. I did not mean to disrespect you all. I just want to highlight what I want. Sorry again

Hi Friends, Thanks for your support but for now I really need just the sorting logic. if my data is in the following order BIbNo AthleteName SchoolAssociation 046 ANIMA ARENGH East Garo Hills District Sports Association 248 Wanda Lyngkhoi Nongstoin District Sports Association 246...

41 Total No. of Heats 41/8= 6 Total No. of Athlete per Heat 41/6= 7 5 Heats of 7 Athletes and 1 Heat of 6 Players 37 Total No. of Heats 37/8= 5 Total No. of Athlete per Heat 37/5= 8 4 Heats of 8 Athletes and 1 Heat of 5 Players 44 Total No. of Heats...

6 Heats of 7 Players Each. Same formula.

Total No. of Heat = Total Athlete / Number of Lane (45 / 8 = 5.65 round off to 6) Total No. of Players per Heat = Total Athlete / Total No. of Heat (45/6=7.5 round off to 8) So the set up will be 5 Heats of 8 Athlete per heat and one Heat of 5 Athletes. Total 6 Heats. It may also be mentioned...