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)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT 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)