Search results

  1. 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...
  2. 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...
  3. 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...
  4. A

    Special Sort

    Hi Friends, I have uploaded a sample database with query named as "HSort" the query output is BIbNo AthleteName SchoolAssociation 046 ANIMA ARENGH East Garo Hills District Sports Association 248 Wanda Lyngkhoi Nongstoin District Sports Association 246 Tiewlari Rynshiang Nongstoin...
  5. A

    Sorting Problem

    Hi friends, I have upload a sample database with query named as "Winner" While sorting the timing of the race, the timing of the athlete who did not finished the race (Absent, Disqualified and Did Not Finished) appear in the top of the table. I want to sort the timing in ascending order but...
  6. A

    Query by group

    Hi friends, I have uploaded one sample database. I want to query the Medal Winners of different Athlete in the following format but i have no idea how to do that. Please help me. Sl No Name of Athlete School/Association Events Participated Gold Silver Bronze Number of Medal won by an...
  7. A

    Automation for Athletics Track and Field Meet (Meet Manager)

    Hi guys, I am a Novice and want to develop a Meet Manager for Athletics Track and Field Meet. In an Athletics Track and Field Meet each School are allowed to register only two players for a particular event (eg. 100m, 200m. High Jump etc.) In Track Events there are only 8 Tracks / Lanes. So...
  8. A

    Validation Rule at Table Level.

    Hi Guys, Please help me how to use Table Validation Rule to validate the following. During Data Entry Ms. Access should validate that there should not be more than two participants from each country under the same category. Can it be done under Table Validation Rule.
  9. A

    Using multiple Options in Checkboxes to add records

    Suppose my form looks like this Can I add records into the event table using multiple options in checkboxes like below : Or can I also use List Box to add records
  10. A

    Custom Sort for sorting records like aaabbbccc to abcabcabc

    Hi everyone, I am new to Access Programming. I am having data as a a a b b b c c c Now I want to sort the sort the record as a b c a b c a b c Anyone kindly hep me. Thanks Amir Kharkongor
Top Bottom