1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
Private Sub Commande17_Click()
Dim rs As New ADODB.Recordset
Dim strsql As String
strsql = "SELECT TOP 6 tirage.num AS numero,SUM(tirage.freq) AS frequence FROM (SELECT numero1 AS num, COUNT(numero1) AS freq FROM tirages GROUP BY numero1 UNION ALL SELECT numero2 AS num, COUNT(numero2) AS freq FROM tirages GROUP BY numero2 UNION ALL SELECT numero3 AS num, COUNT(numero3) AS freq FROM tirages GROUP BY numero3 UNION ALL SELECT numero4 AS num, COUNT(numero4) AS freq FROM tirages GROUP BY numero4 UNION ALL SELECT numero5 AS num, COUNT(numero5) AS freq FROM tirages GROUP BY numero5 UNION ALL SELECT numero6 AS num, COUNT(numero6) AS freq FROM tirages GROUP BY numero6) AS tirage GROUP BY tirage.num ORDER BY Sum(tirage.freq) DESC,tirage.num;"
rs.Open strsql, CurrentProject.Connection
rs.MoveFirst
Numero1.Caption = rs!numero
frequence1.Caption = rs!frequence
rs.MoveNext
Numero2.Caption = rs!numero
frequence2.Caption = rs!frequence
rs.MoveNext
numero3.Caption = rs!numero
frequence3.Caption = rs!frequence
rs.MoveNext
numero4.Caption = rs!numero
frequence4.Caption = rs!frequence
rs.MoveNext
numero5.Caption = rs!numero
frequence5.Caption = rs!frequence
rs.MoveNext
numero6.Caption = rs!numero
frequence6.Caption = rs!frequence
rs.Close
Set rs = Nothing
End Sub |
Partager