Search results

well yes, though the min of times is a sorted field in another query

I tried this but my query came up with no data this is what i put IIf([minoftime]<=[national standard],"National","")

I am trying to get a query to return certain words if a swimming time matches a certain criteria i have tried the if function, whi i know how to use in a spreadsheet how do i achieve an if function/or equivalent in a database?? jen

Ok thanks I will see what i can do with my other queries, and if i cant manage i will come back on here for help. Thanks a lot for your help jen

Any suggestions where i can reed up on sub select statements?

Thanks a lot that seems to work at the moment, i will try it out with lots of different data later Could you explain to me what you did to get this to work please? as i need to do a similar thing to get club records, and would like to have a go myself thanks again jen

That works for the date, time and venue however it doesnt give me all the events

ok thanks a lot

This query is producing the swimmers minimum time, however it is giving their best time at each venue rather than just their best time. Also the date is selecting the first date rather than the date the time was done on.

Its now asking me for a Member.MemberID

do you want me to send you my database to have a look at???

when i enter this the query asks me to enter a venue.eventID ?????????

ok thanks a lot

yes im sure, the age is in the events table because you can have 7 years 50m freestyle male and 8 years 50m freestyle male, which are two different types of events

SELECT Member.Forename, Member.Surname, Event.Gender, Event.Age, Event.Distance, Event.Stroke, Min(Times.Time) AS MinOfTime, Times.Date, Venue.[Name of Pool] FROM Venue INNER JOIN (Member INNER JOIN (Event INNER JOIN Times ON Event.[Event ID] = Times.[Event ID]) ON Member.[Member ID] =...

whats that??

Please could someone reply with some advice thanks jen

I am trying to produce a database that will select a swimmers, best time for each event, and will select the overall best time done by any swimmer in the events. At the moment I am having some trouble with my queries. When trying to get the query to select a swimmers best time for the events...

My tables are: member details Times - (where times for events are recorded) Venues - (linked to times so venues where time is achieved can be stored) Events - (this is linked through ids to the tables below) Stroke Distance Gender Age

Thanks for all your help ive managed to get it to work apart from one thing When i add in the date the time was acheved to the query, It causes all the times to appear again rather than just the minimum ones. Any ideas what i am doing wrong??