Public Db As Database Public Rs As Recordset Set Db = OpenDatabase([chemin de la base]) Set Rs = Db.OpenRecordset("SELECT SUM(Points) FROM Enregistrement WHERE Enregistré = True GROUP BY Club ORDER BY Points", dbOpenSnapshot)
SELECT SUM(Points) AS Total FROM Enregistrement GROUP BY Club ORDER BY Total
SELECT Club, SUM(Points) FROM Enregistrement GROUP BY Club ORDER BY SUM(Points)