Try
SELECT Bowler, Date, Gm1,
( SELECT SUM(Gm1) FROM Rainbow_Lanes L
WHERE L.Bowler = R.Bowler
AND L.Date <= R.Date
) as [Running Total]
FROM Rainbow_Lanes R
where bowler = "Ray McDonough"
ORDER BY r.Date
The last where clause can be excluded to bring back all bowlers.