1 2 3 4 5 6 7
| INSERT INTO T_Calcul ( Reference, Donnees_1, Desi_Primaire, Desi_Secondaire, Donnees_2, Donnees_3, Donnees_4, Donnees_5, Donnees_6, Periode )
SELECT T_Direction.Reference, Sum(T_Direction.Donnees_1) AS SommeDeDonnees_1, T_Direction.Desi_Primaire, T_Direction.Desi_Secondaire, Sum(T_Direction.Donnees_2) AS SommeDeDonnees_2, T_Direction.Donnees_3, Sum(T_Direction.Donnees_4) AS SommeDeDonnees_4, Sum(T_Direction.Donnees_5) AS SommeDeDonnees_5, Sum(T_Direction.Donnees_6) AS SommeDeDonnees_6, "Période" AS Expr1
FROM T_Direction
WHERE (((T_Direction.Boulangerie) Like IIf([Formulaires]![F_Gerants]![Os_User]="General","*",[Formulaires]![F_Gerants]![Os_User])) AND ((T_Direction.Date_Gerant)>=[Formulaires]![F_gerants]![Date_01] And (T_Direction.Date_Gerant)<=[Formulaires]![F_gerants]![Date_02]))
GROUP BY T_Direction.Reference, T_Direction.Desi_Primaire, T_Direction.Desi_Secondaire, T_Direction.Donnees_3, "Période"
HAVING (((T_Direction.Reference)="1") AND ((Sum(T_Direction.Donnees_1))>0))
ORDER BY T_Direction.Reference; |
Partager