Recent content by jenascott

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