1 2 3
| SELECT t_Affaires.*, t_Clients.NomComplet, Get_AffaireNbrDevis([ID_Affaire]) AS NbrDevis, Not IsNull([t_SGILAffaires].[Affaire_ID]) AS SGILAct, t_Clients.ID_Client
FROM ((t_Affaires LEFT JOIN r_AffaireRespContrat ON t_Affaires.ID_Affaire = r_AffaireRespContrat.Affaire_ID) LEFT JOIN t_Clients ON r_AffaireRespContrat.Client_ID = t_Clients.ID_Client) LEFT JOIN t_SGILAffaires ON t_Affaires.ID_Affaire = t_SGILAffaires.Affaire_ID
WHERE (((t_Affaires.Nature)=[Formulaires]![f_AffaireSelect]![ctl_Nature]) AND ((IIf(IsNull([Formulaires]![f_AffaireSelect]![filtre_CA]),True,[CA_TLA_ID]=[Formulaires]![f_AffaireSelect]![filtre_CA]))=True) AND ((IIf([Formulaires]![f_AffaireSelect]![filtre_MesAff],[CA_TLA_ID]=Get_gv("TLA"),True))=True) AND ((IIf([Formulaires]![f_AffaireSelect]![filtre_Gen]=-2,True,[Formulaires]![f_AffaireSelect]![filtre_Gen]=[Generique]))=True) AND ((IIf([Formulaires]![f_AffaireSelect]![filtre_Ext]=-2,True,[Formulaires]![f_AffaireSelect]![filtre_Ext]=[Externe]))=True) AND ((IIf(IsNull([Formulaires]![f_AffaireSelect]![filtre_Etats]),[Etat_ID]<>"SLD" And [Etat_ID]<>"ANN",[Etat_ID]=[Formulaires]![f_AffaireSelect]![filtre_Etats]))=True) AND (([ID_Affaire] & " " & [Libelle] & " " & [t_Affaires].[Societe] & " " & [t_Affaires].[Unite] & " " & [t_Affaires].[Projet] & " " & [t_Affaires].[SousProjet] & " " & [AffaireTypeS].[Value] & " " & [VALs] & " " & Nz([r_AffaireRespContrat].[NomComplet])) Like "*" & [Formulaires]![f_AffaireSelect]![filtre_Divers] & "*")); |
Partager