Search results

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

Max two runners per school

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

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.

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

Thank you very much

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

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

I am uploading again in the earlier version

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

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

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

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

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

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

Please help me

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.

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.

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.

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