You need one query:
SELECT TeamName, SUM(IIF(Result="Pass", 1, 0) AS PassTotal, SUM(IIF(Result="Fail", 1, 0) AS FailTotal, COUNT(Result) AS ResultTotal
FROM YourTableNameHere
GROUP BY TeamName
Then you build a report on it. In the detail section goes all the fields above. Then you should...