Search results

  1. A

    Special Sort

    There can be upto 40 to 50 schools at a time and no preference which runner runs in which heat So sometimes we have to conduct up to 8 to 9 heats before proceeding to finals
  2. A

    Special Sort

    Max two runners per school
  3. A

    Special Sort

    Suppose we have the following entries for 100meters Track Event. BIbNo AthleteName SchoolAssociation 046 ANIMA ARENGH East Garo Hills District Sports Association 248 Wanda Lyngkhoi Nongstoin District Sports Association 246 Tiewlari Rynshiang Nongstoin District Sports Association 190...
  4. A

    Special Sort

    I tried this ORDER BY DCount("1","AthleteEvent","AthleteEvent.SchoolAssociation='" & AthleteEvent.[SchoolAssociation] & "' AND EventID<=" & [EventID]) & AthleteEvent.SchoolAssociation Sometimes it work and sometimes it dont. I dont know why.
  5. 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...
  6. A

    Sorting Problem

    Thank you very much
  7. 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...
  8. A

    Query by group

    This a the sample data AthleteName SchoolAssociation Gender Event Category Gold Silver Bronze SANCTIFY PALE West Jaintia Hills District Sports Association Male 800 Under - 18 1 0 0 SANCTIFY PALE West Jaintia Hills District Sports Association Male 1500 Under - 18 0 1 0 MELIBAD KRO Ri Bhoi...
  9. A

    Query by group

    I am uploading again in the earlier version
  10. 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...
  11. A

    Automation for Athletics Track and Field Meet (Meet Manager)

    I have uploaded my test database as attachment I want to add "ORDER BY DCount("1","AthleteEvent","AthleteEvent.SchoolAssociation='" & AthleteEvent.[SchoolAssociation] & "' AND EventID<= " & [EventID]), AthleteEvent.SchoolAssociation" to "Test Query Form" but I got a syntax error [It is...
  12. 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...
  13. A

    Validation Rule at Table Level.

    Than Thank you very much, for helping a novice like me
  14. A

    Validation Rule at Table Level.

    The solution above is for duplicate entry. But I need to check for 2 similar entry with the same country and under the same category. Only two participants from the same country can participate in the same category. aaa-USA-Swimming bbb-USA-Swimming ccc-UK-Chess ddd-UK-Chess
  15. A

    Validation Rule at Table Level.

    The solution above is for duplicate entry. But I need to check for 2 similar entry with the same country and under the same category. Only two participants from the same country can participate in the same category. aaa-USA-Swimming bbb-USA-Swimming ccc-UK-Chess ddd-UK-Chess
  16. A

    Validation Rule at Table Level.

    Please help me
  17. 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.
  18. A

    Using multiple Options in Checkboxes to add records

    Yes, Thats true. But I can use List Box with Multiple Selection Right. The events can be linked to the events type table. Can you help me with Multi Selection List Box.
  19. A

    Using multiple Options in Checkboxes to add records

    I don't want to use the datasheet view for entry of events for a particular athlete. I want to use checkboxes or list boxes for data entry of events of a particular athlete into the events table.
  20. 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
Back
Top Bottom