1 2 3 4 5 6
| TRANSFORM Count(T1.FRAIS) AS [Total Exécutés Mois]
SELECT Mid([Agences.CODEAGENCE],2,2) AS [Code Agence], Count(T1.FRAIS) AS [Total Exécutés], T2.AGEME AS Agence, "TN0021" & [AGEME] AS [Code Ag], Count(T2.TYPEREJET) AS [Total Rejetés], Count(T2.TYPEREJET) AS Total
FROM ((T1 LEFT JOIN TYPE_DOSSIER ON T1.TYPEDOSSIER = TYPE_DOSSIER.TYPEDOSSIER) LEFT JOIN AGENCES ON T1.COCODE = AGENCES.COCODE) LEFT JOIN T2 ON TYPE_DOSSIER.TYPEDOSSIER = T2.TYPEDOSSIER
WHERE (((Mid([TRANSACTIONDATE],1,6))=40000 Or (Mid([TRANSACTIONDATE],1,6))>40000) AND ((T1.TYPEDOSSIER)="EXECUTEE"))
GROUP BY T1.COCODE, Mid([Agences.CODEAGENCE],2,2), T2.AGEME, "TN0021" & [AGEME]
PIVOT Mid([TRANSACTIONDATE],1,6); |
Partager