Filter a form field based on the value of another in that form

[kitandy]

Yes I can see that but it is outside my current skill / comprehension level.
Please would you write a query (named something like "Q_T_Results_2_All") for me that displays all fields in T_Results_2 but reports the position as 1,2 or 3.
I could then use this as a basis for building the range of reports I plan to create.

 

[arnelgp]

but it is outside my current skill / comprehension level

here is your query.

 

[kitandy]

Many thanks for your patience understanding and time

 

[arnelgp]

your welcome.

 

[kitandy]

Could I please be a bit cheeky
On the form "Enter results" the box "Enter class" can be selected by entering the Class number or from the dropdown menu.where it the stores the class ID. The Class ID is the same as the Class number
Would you please configure it so that it retains this facility but after update displays the class id and the class descrition in a similar way to logging the entrant as shown on the attached image