SELECT tD.*
FROM Data AS tD INNER JOIN (SELECT   [Class]
               , [Score]
        FROM     [Data] AS [Dupe]
        WHERE    (NOT [DSQ])
          AND    ([BestOf]=0)
          AND    ([Score] In (SELECT   TOP 3 [Score]
                              FROM     [Data]
                              WHERE    ([Class]=Dupe.Class)

SELECT Dupe.[Score]
FROM Data AS Dupe
WHERE (((Dupe.[DSQ])=False)
   AND ((Dupe.[BestOf])=0)
   AND ((Dupe.[Score]) In (SELECT   TOP 3 [Score]
                           FROM     [Data]                       
                           WHERE    ([Class]=Dupe.Class)
                             AND    ([Score]>0)

SELECT Dupe.Class, Dupe.DSQ, Dupe.Score, Dupe.*
FROM Data AS Dupe
WHERE (((Dupe.Class)<>"**** - U n k n o w n - NEEDS CLASSIFICATION")
  AND ((Dupe.DSQ)=False)
  AND ((Dupe.BestOf)=0)
  AND ((Dupe.Score)>0
  And (Dupe.Score) In (SELECT TOP 3 Data.Score
                       FROM Data
                       WHERE ((Data.Class=Dupe.Class

SELECT Dupe.Class, Dupe.DSQ, Dupe.Score, Dupe.*
FROM Data AS Dupe
WHERE (((Dupe.Class)<>"**** - U n k n o w n - NEEDS CLASSIFICATION")
  AND ((Dupe.BestOf)=0)
  AND ((Dupe.DSQ)=False)

[B][U]ID    Class  Score   DSQ   BestOf[/U][/B]
11    ACCF     81   False    0
 2    ACCF

SELECT Dupe.Class, Dupe.DSQ, Dupe.Score, Dupe.*
FROM Data AS Dupe
WHERE (((Dupe.Class)<>"**** - U n k n o w n - NEEDS CLASSIFICATION")
   AND ((Dupe.DSQ)=False)
   AND ((Dupe.Score)<>0
   AND  (Dupe.Score) In (SELECT TOP 3 Data.Score
                         FROM Data
                         WHERE (((Data.Class)=(Dupe.Class)