Finally worked it out

SELECT Register.Provider, Register.Service, Count(Register.Service) AS NoofServices, (SELECT COUNT(Issues.ID)

FROM Issues

WHERE Register.Service = Issues.Service) AS NoofIssues

FROM Register

GROUP BY Register.Provider, Register.Service;