I really appreciate your help! There is some trouble with the synthax on my part. Based on your example, I got this:
SELECT Team_name, Score, DCount("1", "Performance", "[Score] >= " & [Score]) AS Podium FROM Team_name;
Can't figure out how to make it work :(
Mike