most recent

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
 
B

Brian Camire

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)
 
Top