ActualDesigner = "SELECT Design.DesignCreationDate, Design.DesignName, Design.DesignType, Design.DesignExpectedDate, Design.DesignCustomerName, Design.DesignDescription, Design.DesignInstruction, Design.DesignRequested, Design.DesignRequestDate, Design.DesignSupplierName, PictureDesign.PictureRank, PictureDesign.PictureAddress, Design.DesignSystem, Design.Designer,
& DLookUp("NameShort","DatabasePeople","FirstName = '" & [Designer] & "'")
& " AS DesignerShort, Design.DesignNrSupplier, Design.DesignStatus, Design.DesignRequestRank, AnimationDesign.AnimationRank, AnimationDesign.DesignAnimationRef, AnimationDesign.Animation, AnimationDesign.AnimationCodeBar, AnimationDesign.AnimationColour, AnimationDesign.AnimationDesignation, AnimationDesign.AnimationRef, AnimationDesign.AnimationType, FabricDesign.FabricRank, FabricDesign.DesignFabricref, FabricDesign.Fabric, FabricDesign.FabricCodeBar, FabricDesign.FabricColor, FabricDesign.FabricComposition, FabricDesign.FabricConstruction, " _
& "FabricDesign.FabricReference, FabricDesign.FabricTreatment, FabricDesign.FabricWeight " _
& "FROM ((Design INNER JOIN PictureDesign ON Design.DesignSystem = PictureDesign.DesignSystem) INNER JOIN AnimationDesign ON Design.DesignSystem = AnimationDesign.DesignSystem) INNER JOIN FabricDesign ON Design.DesignSystem = FabricDesign.DesignSystem " _
& "WHERE (((Design.DesignCreationDate) Is Not Null) AND ((Design.DesignRequestDate) Is Null) AND ((PictureDesign.PictureRank) = 1) AND ((AnimationDesign.AnimationRank) = 1) AND ((FabricDesign.FabricRank) = 1) AND ((Design.DesignCancelDate) Is Null) AND ((Design.DesignApprovedDate) Is Null)) " _
& "ORDER BY Design.DesignCreationDate, Design.DesignName;"
Partager