1 2 3 4 5 6 7 8 9
|
texte_SQL = "SELECT D.[Circuit], D.[Point], AVG(D.[Intensite]) AS Moyenne, D.[Caractere], COUNT(D.[Caractere]) AS Nbr, " & _
"format(SUM(IIF(D.[Frequence]=0,1,0))/Nbr, '#0%') AS FreqBouffee, " & _
"format(SUM(IIF(D.[Frequence]=1,1,0))/Nbr, '#0%') AS FreqContinue, " & _
"format(SUM(IIF(D.[Frequence]=null,1,0))/Nbr, '#0%') AS FreqNull " & _
"FROM [Donnees$] D " & _
"WHERE (D.[Circuit]=" & intCircuit & " AND D.[Point]=" & intPoint & ")" & _
" GROUP BY D.[Caractere], D.[Circuit], D.[Point];" |
Partager