Here is what I have for a report that selects the top 3 winners:

Code:
SELECT Dupe.Class, Dupe.Score, Dupe.ID, Dupe.FName, Dupe.LName, Dupe.Year, Dupe.Make, Dupe.Model, Dupe.Judge
FROM Data AS Dupe
WHERE (((Dupe.Score)<>0 And (Dupe.Score) In (SELECT TOP 3 Data.Score FROM Data WHERE (((Data.Class)=Dupe.[Class])) ORDER BY Data.Score DESC)))
ORDER BY Dupe.Class, Dupe.Score DESC , Dupe.ID;
...