SELECT Trim([Adr].[Vorname] & " " & [Adr].[Name1]) AS Kunde, Sum(Std.DauerAbrechnung) AS OffeneStunden, System_MA.Name
FROM (Adr INNER JOIN Std ON Adr.Kdnr = Std.adrkdnr) INNER JOIN System_MA ON Adr.MA = System_MA.Kuerzel
GROUP BY Trim([Adr].[Vorname] & " " & [Adr].[Name1]), Std.Abgerechnet, System_MA.Name
HAVING (((Std.Abgerechnet)=False))
ORDER BY System_ma.name,sum(std.Dauerabrechnung) desc,Trim([Adr].[Vorname] & " " & [Adr].[Name1]);