1 2 3 4
|
FROM T_Code_Postaux INNER JOIN T_Contacts ON T_Code_Postaux.IDLocalite=T_Contacts.NumLocalite
WHERE (((T_Contacts.FamillePossible)=IIf(IsNull(formulaires!f_choisir_Contacts!mfapo),[famillepossible],formulaires!f_choisir_contacts!mfapo)) And ((T_Contacts.FamilleYFU)=IIf(IsNull(formulaires!f_choisir_contacts!mfay),[familleyfu],formulaires!f_choisir_contacts!mfay)) And ((T_Contacts.DemandeInfo)=IIf(IsNull(formulaires!f_choisir_contacts!mdein),[demandeinfo],formulaires!f_choisir_contacts!mdein)) And ((T_Contacts.YFUNews)=IIf(IsNull(formulaires!f_choisir_contacts!myne),[yfunews],formulaires!f_choisir_contacts!myne)) And ((T_Contacts.Returnees)=IIf(IsNull(formulaires!f_choisir_contacts!mret),[returnees],formulaires!f_choisir_contacts!mret)) And ((T_Code_Postaux.CP)=IIf(IsNull(formulaires!f_choisir_contacts!mcp),[cp],formulaires!f_choisir_contacts!mcp)) And ((T_Code_Postaux.LocalitÈ)=IIf(IsNull(formulaires!f_choisir_contacts!mloc),[localitÈ],formulaires!f_choisir_contacts!mloc)) And ((T_Code_Postaux.province)=IIf(IsNull(formulaires!f_choisir_contacts!mpro),[province],formulaires!f_choisir_contacts!mpro)) And ((T_Code_Postaux.Pays)=IIf(IsNull(formulaires!f_choisir_contacts!mpay),[pays],formulaires!f_choisir_contacts!mpay))) And
T_Contacts.mail Is Not Null; |
Partager