I have a database consisting of teams who compete irregularly, what I wish to do is query a table to return the most recent 5 results for each team, I can not use a date value (to select the records) as in the last month some teams may have competed 12 times while others only 5 times or less.
I need to return the actual records rather than just count the number of records that exist in the criteria.
The field names are basically team_name , points, and date (the later being the match date).
Any help or pointing in the right direction would be appreciated.
Nigel
I need to return the actual records rather than just count the number of records that exist in the criteria.
The field names are basically team_name , points, and date (the later being the match date).
Any help or pointing in the right direction would be appreciated.
Nigel