1 2 3 4 5
| SELECT T_PDTS.CIP_PK, T_PDTS.LIBELLE, T_PDTS.[CDT° STOCKAGE], T_STOCK_ENTREE.EntreeLot, T_STOCK_ENTREE.EntreePeremption, T_STOCK_ENTREE.EntreeFacturation, StockLotFactADate([T_STOCK_ENTREE]![CIP_FK],Date$(),[T_STOCK_ENTREE]![EntreeLot],[T_STOCK_ENTREE]![EntreeFacturation]) AS [Stock Total], Last(T_STOCK_ENTREE.EntreeDate) AS DernierDeEntreeDate, Last(R_PDTS_COMMENT_SNA.EntreeDate) AS [Date Commentaires], Last(R_PDTS_COMMENT_SNA.EntreeCommentaires) AS DernierDeEntreeCommentaires, r_Stk_Select.CIP_FK
FROM ((T_PDTS INNER JOIN T_STOCK_ENTREE ON T_PDTS.CIP_PK = T_STOCK_ENTREE.CIP_FK) LEFT JOIN R_PDTS_COMMENT_SNA ON (T_STOCK_ENTREE.CIP_FK = R_PDTS_COMMENT_SNA.CIP_PK) AND (T_STOCK_ENTREE.EntreeLot = R_PDTS_COMMENT_SNA.EntreeLot)) LEFT JOIN r_Stk_Select ON (T_STOCK_ENTREE.CIP_FK = r_Stk_Select.CIP_FK) AND (T_STOCK_ENTREE.EntreeLot = r_Stk_Select.EntreeLot)
GROUP BY T_PDTS.CIP_PK, T_PDTS.LIBELLE, T_PDTS.[CDT° STOCKAGE], T_STOCK_ENTREE.EntreeLot, T_STOCK_ENTREE.EntreePeremption, T_STOCK_ENTREE.EntreeFacturation, StockLotFactADate([T_STOCK_ENTREE]![CIP_FK],Date$(),[T_STOCK_ENTREE]![EntreeLot],[T_STOCK_ENTREE]![EntreeFacturation]), r_Stk_Select.CIP_FK
HAVING (((StockLotFactADate([T_STOCK_ENTREE]![CIP_FK],Date$(),[T_STOCK_ENTREE]![EntreeLot],[T_STOCK_ENTREE]![EntreeFacturation]))<>0))
ORDER BY T_PDTS.LIBELLE; |
Partager