INSERT INTO Tbl_TempNvxCptesCli_EcartFac ( CLI_CODCLI, EcartMois, ALVNATURE, MaxDateFre, MaxNoFacture )
SELECT DISTINCT dbo_CLIENT.CLI_CODCLI, DateDiff('m',Max(dbo_VLIGNES_FACTVTE!DLVORDERDAT),Formulaires!FrmChoixDate!txtDebut) AS Expr2, dbo_VLIGNES_FACTVTE.ALVNATURE, Max(dbo_VLIGNES_FACTVTE.DLVINVOICEDAT) AS MaxDeDLVINVOICEDAT, Max(dbo_VLIGNES_FACTVTE.ALVPIECENO) AS MaxDeALVPIECENO
FROM dbo_CLIENT LEFT JOIN dbo_VLIGNES_FACTVTE ON dbo_CLIENT.CLI_CODCLI = dbo_VLIGNES_FACTVTE.ALVCUSTNO
GROUP BY dbo_CLIENT.CLI_CODCLI, dbo_VLIGNES_FACTVTE.ALVNATURE, dbo_CLIENT.REP_CODE, dbo_CLIENT.CLI_OUVERT
HAVING (((dbo_VLIGNES_FACTVTE.ALVNATURE)="papeterie") AND ((dbo_CLIENT.REP_CODE)="IB") AND ((dbo_CLIENT.CLI_OUVERT)="F"))
ORDER BY dbo_CLIENT.CLI_CODCLI;
Partager