1 2 3
| SELECT TABaff.NUMaff, TABaff.TYPetd, TABaff.LOCaff, TABaff.INTaff, TABstat.CODstat, UCase(Left([PREres],1) & "." & Left([NOMres],3)) AS RESP
FROM TABstat, TABres, TABaff
WHERE (((TABaff.NUMaff) Like IIf(IsNull([Formulaires]![FORMlist]![filtreAFF]),"*","*" & [Formulaires]![FORMlist]![filtreAFF] & "*")) AND ((TABaff.TYPetd) Like IIf(IsNull([Formulaires]![FORMlist]![filtreTYPetd]),"*","*" & [Formulaires]![FORMlist]![filtreTYPetd] & "*")) AND ((TABaff.LOCaff) Like IIf(IsNull([Formulaires]![FORMlist]![filtreLOC]),"*","*" & [Formulaires]![FORMlist]![filtreLOC] & "*")) AND ((TABaff.INTaff) Like IIf(IsNull([Formulaires]![FORMlist]![filtreINT]),"*","*" & [Formulaires]![FORMlist]![filtreINT] & "*")) AND ((TABstat.CODstat) Like IIf(IsNull([Formulaires]![FORMlist]![filtreSTAT]),"*","*" & [Formulaires]![FORMlist]![filtreSTAT] & "*")) AND ((UCase(Left([PREres],1) & "." & Left([NOMres],3))) Like IIf(IsNull([Formulaires]![FORMlist]![filtreRESP]),"*","*" & [Formulaires]![FORMlist]![filtreRESP] & "*")) AND ((TABstat.IDstat)=[TABaff].[STATaff]) AND ((TABres.IDres)=[TABaff].[RESaff])); |
Partager