Search results

Thanks, I have done a query using just member id, event id and time and managed to get the fastest time only to appear How do i then join it to get the members actual name and details of the event (stroke, distance, age group,m of f)?

SELECT Member.Forname, Member.Surname, Strokes.Name AS Strokes_Name, Distance.Distance, Age.Age, Gender.Gender, Times.Date, Venues.Name AS Venues_Name, Min(Times.Time) AS MinOfTime FROM Venues INNER JOIN (Member INNER JOIN (Strokes INNER JOIN (Gender INNER JOIN ((Distance INNER JOIN (Age INNER...

Sorry im really thick at this stuff!!! Basically this is what i want to do i have data like this: jennifer.............froncrawl..........50m..............01.10.45 jennifer..............froncrawl..........50m..............01.09.34 Andrew..............froncrawl..........50m..............01.02.00...

I tried that but it still shows swimmers slower times for the same event Do you have any other suggestions??

Hi I have a database that has tables with swimmers times for each event how do i create a query to only show swimmers best times for each event rather than all the times they have ever achieved?? thanks jen