Returning only values I want

[Clott]

Hi all

I am organising a race event. Entrants will select which event to enter and submit times from a previous race. So I am trying to produce a query based on a table of members that will return only the names of entrants, the race(s) they are entering and their previous time(s).
I have 2 tables - 1 consisting of - Name, tick boxes for 25m, 100m, 200m, and the second table for previous times.
I want to eventually sort the times into order for each race so that they can be split into heats based on previous times.
So, the query I have set up is successful in returning those who wish to enter. (I have set the criteria to 'Yes' in 'Participating' column). However, I am failing in setting further criteria so that it returns the names and times against each race. It either returns everyone or none.
I hope I have explained it properly. I would appreciate any help at all.
Many thanks

 

[Mr Smin]

Can you post the SQL that you have generated in the query builder?

 

[Clott]

Thanks for replying. I am going to spend some time this evening on restructuring the db by creating new tables to accommodate our future needs. Unfortunately the current db has evolved over time and has become quite unwieldy. I'll re-post with the info you mentioned in due course.
Many thanks

 

[Clott]

Thanks. Rather than jumping in, I'm going to spend time studying the tutorials so hopefully I will get it right from the start. So I will use the tips and get back in due course!

 

[Clott]

OK. I have re-written the tables/forms and so far I have -
Table for members (450)
Table for swimming strokes (22)
Table for best times
There is quite a lot of personal information required for each member so majority of that appears in a form and I have done a sub-form detailing best times as a horizontal line on each member record.
This is now where I am struggling!
I have set up a new table with name, a tick box to confirm attendance at next event, a row for each stroke with best time, and a row for a tick box against each event.
What I want to achieve is a report for each stroke, showing name and sorting by best times.
I don't understand how I can have a single column for the strokes.
Many thanks for any help

 

[Clott]

Thanks for your help so far, Pat. I have now re-designed the tables and forms. I have created a sub-form with a single column as you suggested and originally had a table as the record source. However, I needed to sort a field so noted from threads on here that I should have a query as the source. I have changed that but now have annoying vertical scroll bars and horizontal record navigation keys which I can't disable.
Other answers to this problem on here appear to apply to a form, not a query. When I go into subform design view, there is just a blank query box so I can't see the 2 field boxes and there aren't the options to get rid of the bars in the Properties list.
As always, help much appreciated.