most recent

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi there,
My data base has names, dates and scores associated with
the dates.
Can anybody tell me how I can extract from that data base
the most recent 20 games for each or any name.

Thanks
George
 
You might try a query whose SQL looks something like this:

SELECT
[Your Table].*
FROM
[Your Table]
WHERE
[Your Table].[Date] In
(SELECT TOP 20
[Self].[Date]
FROM
[Your Table] AS [Self]
WHERE
[Self].[Name] = [Your Table].[Name]
ORDER BY
[Self].[Date] DESC)
 
Back
Top