SELECT [Month], [Year], [SCORE]
FROM MyTable
WHERE [Month] & [Year] IN (SELECT [Month] & [Year] AS ID, Max(FormatDateTime([Month] & "/1/" & [Year]) FROM MyTable WHERE [SCORE]<>0)
SELECT [Month], [Year], [SCORE]
FROM scores
WHERE [Month] & [Year] IN (SELECT [Month] & [Year] AS ID, Max(FormatDateTime([Month] & "/1/" & [Year])) FROM scores WHERE [SCORE]<>0)
but got the dreaded
You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause
Revise the SELECT staement of the subquery to request only one field
Dec 2009 200 record
Should also mention that once the non zero score value is found all entries below it will all have zero scores