1 2 3 4 5 6
|
SELECT LINC_SECU_ECR.NUMEROCOT, LINC_SECU_ECR.PERIODE, Sum(LINC_SECU_ECR.DEBIT) AS SommeDeDEBIT, Sum(LINC_SECU_ECR.CREDIT) AS SommeDeCREDIT,
LINC_SECU_ECR.NATURE, [SommeDeDEBIT]-[SommeDeCREDIT] AS Expr1
FROM J19012016 LEFT JOIN LINC_SECU_ECR ON (J19012016.NUMEROCOT=LINC_SECU_ECR.NUMEROCOT) AND (J19012016.PERIODE=LINC_SECU_ECR.PERIODE)
GROUP BY LINC_SECU_ECR.NUMEROCOT, LINC_SECU_ECR.PERIODE, LINC_SECU_ECR.NATURE, [SommeDeDEBIT]-[SommeDeCREDIT]
HAVING (((LINC_SECU_ECR.NATURE)<>"R50" And (LINC_SECU_ECR.NATURE)<>"R58" And (LINC_SECU_ECR.NATURE)<"R56")) |
Partager