1 2 3 4
| SELECT CONSO_BASE_HI_CODE_COM.annee_mois, CONSO_BASE_HI_CODE_COM.REGION, CONSO_BASE_HI_CODE_COM.no_societe, CONSO_BASE_HI_CODE_COM.nom_societe, BASE_Plan_comm.no_agence_comm, BASE_Plan_comm.compute_0004 AS agence_comm, BASE_Plan_comm.no_commercial, BASE_Plan_comm.compute_0006 AS commercial, CONSO_BASE_HI_CODE_COM.typologie, Count(CONSO_BASE_HI_CODE_COM.typologie) AS NB, Sum(CONSO_BASE_HI_CODE_COM.montant_TTC) AS SommeDemontant_TTC
FROM CONSO_BASE_HI_CODE_COM LEFT JOIN BASE_Plan_comm ON CONSO_BASE_HI_CODE_COM.IDCODE = BASE_Plan_comm.ID
GROUP BY CONSO_BASE_HI_CODE_COM.annee_mois, CONSO_BASE_HI_CODE_COM.REGION, CONSO_BASE_HI_CODE_COM.no_societe, CONSO_BASE_HI_CODE_COM.nom_societe, BASE_Plan_comm.no_agence_comm, BASE_Plan_comm.compute_0004, BASE_Plan_comm.no_commercial, BASE_Plan_comm.compute_0006, CONSO_BASE_HI_CODE_COM.typologie
HAVING (((CONSO_BASE_HI_CODE_COM.annee_mois) Between [Formulaires]![Export]![annee_mois_debut] And [Formulaires]![Export]![annee_mois_fin])); |
Partager