Discussion :

[haludo]

Bonsoir,

Voilà ma requete :

SELECT Count FROM Resacc WHERE (Resacc.Resprompt=1) AS Expr1,
Count FROM Resacc WHERE (Resacc.Reseffic=1) AS Expr2,
Count FROM Resacc WHERE (Resacc.Rescourt=1) AS Expr3,
Count FROM Resacc WHERE (Resacc.Accprompt=1) AS Expr4,
Count FROM Resacc WHERE (Resacc.Acceffic=1) AS Expr5,
Count FROM Resacc WHERE (Resacc.Acccourt=1) AS Expr6;

Je voudrai avoir plusieurs COUNT dans ma requete, mais je ne sais pas si c'est possible, moi je l'ai tenté comme ça mais il me fait une erreur :

erreur de syntaxe (operateur absent) dans l'expression (Resacc.Resprompt=1) AS Expr1,
Count FROM Resacc WHERE (Resacc.Reseffic=1) AS Expr2,
Count FROM Resacc WHERE (Resacc.Rescourt=1) AS Expr3,
Count FROM Resacc WHERE (Resacc.Accprompt=1) AS Expr4,
Count FROM Resacc WHERE (Resacc.Acceffic=1) AS Expr5,
Count FROM Resacc WHERE (Resacc.Acccourt=1) AS Expr6;

Si qq'un pouvait m'éclairer ce serait sympathique

[random]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
 
select sum(c1) as ch1,sum(c2) as ch2,sum(c3) as ch3 from
(SELECT Count(champ1) AS c1,0 as c2, 0  as c3 FROM matable WHERE champ1=1
union all
SELECT 0 AS c1,Count(champ2) as c2, 0  as c3 FROM matable WHERE champ2=2
union all
SELECT 0 AS c1,0  as c2, count(champ3)   as c3 FROM matable WHERE champ3=0);

[soltani1]

Bonjour,

Essaie

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
SELECT Sum(IIf(Resacc.Reseffic=1,1,0)) AS Expr1, Sum(IIf(Resacc.Rescourt=1,1,0)) AS Expr2,....
FROM table1;

A+

[haludo]

Grand merci Soltani1 , ça marche nickel...