SELECT Design.DesignCancelDate, Design.DesignCreationDate, Design.DesignApprovedDate, Design.DesignExpectedDate, Design.DesignRequestDate, Design.DesignConfirmedDate, Design.DesignNrDate, Design.DesignRejectDate, AnimationDesign.AnimationRank, FabricDesign.FabricRank, PictureDesign.PictureRank, Design.DesignConfirmed, Design.DesignName, Design.DesignSupplierMerchandiser, Design.DesignType, DLookUp("NameShort","DatabasePeople","FirstName = '" & [Designer] & "'") AS DesignerShort, Design.DesignSystem, Design.DesignSupplierName, VraiFaux([DesignNrDate]>1, "Rep", "") AS Rep
FROM ((Design INNER JOIN AnimationDesign ON Design.DesignSystem = AnimationDesign.DesignSystem) INNER JOIN FabricDesign ON Design.DesignSystem = FabricDesign.DesignSystem) INNER JOIN PictureDesign ON Design.DesignSystem = PictureDesign.DesignSystem
WHERE (((Design.DesignCancelDate) Is Null) AND ((Design.DesignCreationDate) Is Not Null) AND ((Design.DesignApprovedDate) Is Null) AND ((Design.DesignExpectedDate) Is Not Null) AND ((Design.DesignRequestDate) Is Not Null) AND ((Design.DesignConfirmedDate) Is Null) AND ((Design.DesignNrDate)=1) AND ((Design.DesignRejectDate) Is Null) AND ((AnimationDesign.AnimationRank)=1) AND ((FabricDesign.FabricRank)=1) AND ((PictureDesign.PictureRank)=1)) OR (((Design.DesignCancelDate) Is Null) AND ((Design.DesignCreationDate) Is Not Null) AND ((Design.DesignApprovedDate) Is Null) AND ((Design.DesignExpectedDate) Is Not Null) AND ((Design.DesignRequestDate) Is Not Null) AND ((Design.DesignConfirmedDate) Is Not Null) AND ((Design.DesignNrDate)>1) AND ((Design.DesignRejectDate)<[DesignrequestDate] And (Design.DesignRejectDate)>[DesignConfirmedDate]) AND ((AnimationDesign.AnimationRank)=1) AND ((FabricDesign.FabricRank)=1) AND ((PictureDesign.PictureRank)=1))
ORDER BY Design.DesignRequestDate;
Partager