SQLOL

SELECT RunsMasterPE.LeaderboardID, RunsMasterPE.RunDate,
(
SELECT SUM(Testing1) AS Testing2
FROM
(
SELECT MAX(IIf((1-2^((100-(RunsMasterPE.RunDate-RunsMasterPE2.RunDate))/30.4375))/(1-2^(100/30.4375))>0,(1-2^((100-(RunsMasterPE.RunDate-RunsMasterPE2.RunDate))/30.4375))/(1-2^(100/30.4375)),0)) AS Testing1
FROM RunsMasterPE AS RunsMasterPE2
WHERE RunsMasterPE.LeaderboardID = RunsMasterPE2.LeaderboardID AND (RunsMasterPE.RunDate-RunsMasterPE2.RunDate <= 100) AND (RunsMasterPE.RunDate-RunsMasterPE2.RunDate >= 0)
GROUP BY RunsMasterPE2.LeaderboardID, RunsMasterPE2.UserID
)
)
FROM RunsMasterPE
GROUP BY RunsMasterPE.LeaderboardID, RunsMasterPE.RunDate;