Automation for Athletics Track and Field Meet (Meet Manager) (1 Viewer)

[amirkharkongor]

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 if the total no. of Entries for a particular Track Event is 20, the no. of Heats must be divided by 8 in such a way that two schools does not compete in the same Heat.

example

I want to generate a query so that the results will be as follows

 

[arnelgp]

here is a simple track and field db.

 

[amirkharkongor]

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 working in the "Test AthleteData Query"]




I want to put the following validations in the "Test Data Entry Form"

1. Each Athlete can participate for only 2 individual Events (100m, 200m, 400m etc.) and one Relay Event (4x100m and 4x400m)
2. Only two participants from the same School/Association can participate in the same Event.