Search results

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

Many thanks for your patience understanding and time

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

Thats great Just a question now. While it all appears to be working fine why does the "position" field store the number 55 in the table regardless of the value (1, 2 or3) entered in the form. Also how will this display when I start building reports

Hi Thats great. Is it possible to also select the entrant by inputting their number

Yes I agree seeing the name displayed is good. However the person entering the data receives it in the format Class Number Position Entrants Number (without their name)

Apologies for being a pain but we need to record the entrant number and select it by entering their number rather than the name as shown

Thanks that's the position sorted However the prize value in this case should be £1.50, £1.00 and £0.50 respectively for first, second and 3rd. As you will see from the screen shot this is not the case. I am very appreciative of your assistance and patience

Many thanks thats great except when a position is selected it stores the class number rather than the position in the "Position" field.see attached image Also could I be cheeky and ask if you could arrange for the value of the prize to be auto entered in the prize field when the position is...

Hi Its the"Enter results" button

DB attached as requested

yes please give advice re how to upload

Hi I have a database recording competition entry's and results. The competition has a range of numbered classes each of which is awarded first , second and third. Monetary prizes are awarded but values vary depending on class. I have created A table (classes) A table (Prizes) which records the...

I have been using access for many years but, apart from one days training, am self taught. I mostly used the built in functions and have done very little using code.