1 2 3 4
| SELECT T_Action.IDAction, T_Action.ForeseenDate, T_AG.AGTitle, T_Theme_Strat.ThemeStratTitle, [T-Target].TargetTitle, T_Theme_AG.ThemeAGTitle, [T-Target].TargetTitle, T_Action.Description, T_Action.Message, T_Action.ExtInternet, T_Action.ExtSocialMedia, T_Action.ExtBrochure, T_Action.ExtAffichage, T_Action.ExtEcrans, T_Action.ExtPublicite, T_Action.ExtCommuniquePresse, T_Action.ExtConférencePresse, T_Action.ExtCourrier, T_Action.ExtMassMailing, T_Action.ExtSalon, T_Action.IntIntranet, T_Action.IntSocialMedia, T_Action.IntFininfoElectronique, T_Action.IntMNL, T_Action.IntBrochure, T_Action.IntSeminaire, T_Action.IntAffichage, T_Action.IntCourrier, T_Action.IntMassMailing, T_Action.ChannelComment, T_Action.DependanceCSC, T_Action.DependanceAutre, T_Action.Budget, T_Action.Comments, T_Action.Contact, T_Action.Status, T_Action.Postponed, T_Action.Delayed, T_Action.Evaluation
FROM [T-Target] RIGHT JOIN (T_Theme_Strat RIGHT JOIN (T_Theme_AG RIGHT JOIN (T_Target_AG RIGHT JOIN (T_AG INNER JOIN T_Action ON T_AG.IDAG = T_Action.RefAG) ON T_Target_AG.IDTargetAG = T_Action.RefTargetAG) ON T_Theme_AG.IDThemeAG = T_Action.RefThemeAG) ON T_Theme_Strat.IDThemeStrat = T_Action.RefThemeStrat) ON [T-Target].IDTarget = T_Action.RefTarget
WHERE (((T_Action.ForeseenDate) Between Nz([Formulaires]![F_Search]![TxtDateStart],[T_Action]![ForeseenDate]) And Nz([Formulaires]![F_Search]![TxtDateEnd],[T_Action]![ForeseenDate])) AND ((T_Action.Description) Like "*" & Nz([Formulaires]![F_Search]![TxtDescription],[T_Action]![Description]) & "*") AND ((T_Action.Message) Like "*" & Nz([Formulaires]![F_Search]![TxtMessage],[T_Action]![Message]) & "*") AND ((T_Action.ExtInternet)=IIf([Formulaires]![F_Search]![CochExtInternet]=-1,-1,[ExtInternet])) AND ((T_Action.ExtSocialMedia)=IIf([Formulaires]![F_Search]![CochExtSocialMedia]=-1,-1,[ExtSocialMedia])) AND ((T_Action.ExtBrochure)=IIf([Formulaires]![F_Search]![CochExtBrochure]=-1,-1,[ExtBrochure])) AND ((T_Action.ExtAffichage)=IIf([Formulaires]![F_Search]![CochExtAffichage]=-1,-1,[ExtAffichage])) AND ((T_Action.ExtEcrans)=IIf([Formulaires]![F_Search]![CochExtEcrans]=-1,-1,[ExtEcrans])) AND ((T_Action.ExtPublicite)=IIf([Formulaires]![F_Search]![CochExtPublicite]=-1,-1,[ExtPublicite])) AND ((T_Action.ExtCommuniquePresse)=IIf([Formulaires]![F_Search]![CochExtCommunique]=-1,-1,[ExtCommuniquePresse])) AND ((T_Action.ExtConférencePresse)=IIf([Formulaires]![F_Search]![CochExtConference]=-1,-1,[ExtConférencePresse])) AND ((T_Action.ExtCourrier)=IIf([Formulaires]![F_Search]![CochExtCourrier]=-1,-1,[ExtCourrier])) AND ((T_Action.ExtMassMailing)=IIf([Formulaires]![F_Search]![CochExtMassMailing]=-1,-1,[ExtMassMailing])) AND ((T_Action.ExtSalon)=IIf([Formulaires]![F_Search]![CochExtSalon]=-1,-1,[ExtSalon])) AND ((T_Action.IntIntranet)=IIf([Formulaires]![F_Search]![CochIntIntranet]=-1,-1,[IntIntranet])) AND ((T_Action.IntSocialMedia)=IIf([Formulaires]![F_Search]![CochIntSocialMedia]=-1,-1,[IntSocialMedia])) AND ((T_Action.IntFininfoElectronique)=IIf([Formulaires]![F_Search]![CochIntFininfoElectronique]=-1,-1,[IntFininfoElectronique])) AND ((T_Action.IntMNL)=IIf([Formulaires]![F_Search]![CochIntMNL]=-1,-1,[IntMNL])) AND ((T_Action.IntBrochure)=IIf([Formulaires]![F_Search]![CochIntBrochure]=-1,-1,[IntBrochure])) AND ((T_Action.IntSeminaire)=IIf([Formulaires]![F_Search]![CochIntSeminaire]=-1,-1,[IntSeminaire])) AND ((T_Action.IntAffichage)=IIf([Formulaires]![F_Search]![CochIntAffichage]=-1,-1,[IntAffichage])) AND ((T_Action.IntCourrier)=IIf([Formulaires]![F_Search]![CochIntCourrier]=-1,-1,[IntCourrier])) AND ((T_Action.IntMassMailing)=IIf([Formulaires]![F_Search]![CochIntMassMailing]=-1,-1,[IntMassMailing])) AND ((T_Action.Status)=Nz([Formulaires]![F_Search]![LstStatus],[Status])) AND ((T_Action.Postponed)=IIf([Formulaires]![F_Search]![CochPostponed]=-1,-1,[Postponed])) AND ((T_Action.Delayed)=IIf([Formulaires]![F_Search]![CochDelayed]=-1,-1,[Delayed])) AND ((T_Action.IntFininfoPapier)=IIf([Formulaires]![F_Search]![CochIntFininfoPapier]=-1,-1,[IntFininfoPapier])) AND ((T_AG.IDAG)=Nz([Formulaires]![F_Search]![LstAG],[T_AG]![IDAG])) AND ((T_Theme_Strat.IDThemeStrat)=Nz([Formulaires]![F_Search]![LstTheme],[T_Theme_Strat]![IDThemeStrat])) AND (([T-Target].IDTarget)=Nz([Formulaires]![F_Search]![LstTarget],[T-Target]![IDTarget])) AND ((T_Theme_AG.IDThemeAG)=Nz([Formulaires]![F_Search]![LstThemeAG],[T_Theme_AG]![IDThemeAG])) AND ((T_Target_AG.IDTargetAG)=Nz([Formulaires]![F_Search]![LstTargetAG],[T_Target_AG]![IDTargetAG])))
ORDER BY T_Action.ForeseenDate; |
Partager