Returning the last 5 records for a each unique value

[GavZ]

I'm new to this forum so hoping someone could help. I have a table that contains a list of sports results, and I'd like to be able to retrive the last five home results for each team, but am really strugggling how to do this as am fairly new to Access.



The table has the following format:

ID
Date
HomeTeam
AwayTeam
HomeTeamScore
AwayTeamScore

I've been able to this on a team by team basis by selecting that team in the criteria and then restricting the return to 5 after sorting desc by date. But I want to be able to seel the last 5 results for all the teams without having to individually select each one.

Any help would be great appreciated.

[June7]

Review http://allenbrowne.com/subquery-01.html#TopN