1 2 3 4 5
| SELECT TOP 24 PRODUCTION.APPELLATION, PRODUCTION.COULEUR, PRODUCTION.[TYPE PRODUCTION], Month([Date]) AS Expr2, Sum(OPERATIONS.[Entrées Hl]) AS [SommeDeEntrées Hl], Sum(OPERATIONS.[vrac DAA/DAC]) AS [SommeDevrac DAA/DAC], Sum(OPERATIONS.[bouteille neutre export DAA/DAC]) AS [SommeDebouteille neutre export DAA/DAC], Sum([lies])+Sum([Pertes]) AS [Lies/Pertes], Sum(OPERATIONS.[DSA/DSAC tickets ou fracturettes]) AS [SommeDeDSA/DSAC tickets ou fracturettes], Sum(OPERATIONS.[Bouteilles CRD ou apposition de CRD]) AS [SommeDeBouteilles CRD ou apposition de CRD], Sum(OPERATIONS.[Consommation familiale, dégustation, analyses]) AS [SommeDeConsommation familiale, dégustation, analyses], Sum(OPERATIONS.[replis, déclassement]) AS [SommeDereplis, déclassement], Sum(OPERATIONS.dplc) AS SommeDedplc, Sum([lies])+Sum([Pertes])+Sum([replis, déclassement])+Sum([Consommation familiale, dégustation, analyses])+Sum([Bouteilles CRD ou apposition de CRD])+Sum([DSA/DSAC tickets ou fracturettes])+Sum([bouteille neutre export DAA/DAC])+Sum([vrac DAA/DAC]) AS Totalsorties, Sum([Entrées Hl])-(Sum([lies])+Sum([Pertes])+Sum([replis, déclassement])+Sum([Consommation familiale, dégustation, analyses])+Sum([Bouteilles CRD ou apposition de CRD])+Sum([DSA/DSAC tickets ou fracturettes])+Sum([bouteille neutre export DAA/DAC])+Sum([vrac DAA/DAC])) AS SthéoFDM
FROM PRODUCTION INNER JOIN OPERATIONS ON PRODUCTION.[NUM PRODUCTION] = OPERATIONS.[NUM PRODUCTION]
GROUP BY PRODUCTION.APPELLATION, PRODUCTION.COULEUR, PRODUCTION.[TYPE PRODUCTION], Month([Date]), Year([Date])
HAVING (((PRODUCTION.[TYPE PRODUCTION])=2) AND ((Month([Date]))=[Formulaires]![Edition DRM]![txtmois]) AND ((Year([Date]))=[Formulaires]![Edition DRM]![txtannée]))
ORDER BY PRODUCTION.APPELLATION, PRODUCTION.COULEUR; |
Partager