Recent content by amirkharkongor

  1. A

    Record validation

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

    Record validation

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

    Medal Tally

    Thank you so much for helping me.
  4. A

    Medal Tally

    No I don't have.
  5. A

    Medal Tally

  6. A

    Medal Tally

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

    Medal Tally

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

    Special Sort

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

    Special Sort

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

    Special Sort

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

    Special Sort

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

    Lookup

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

    Lookup

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

    Lookup

    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"
  15. A

    Lookup

    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...
See more
Top Bottom