1 2 3
| SELECT [_Catalogue].[N° SAP], [_Catalogue].Titre, [_Catalogue].Branche, [_Catalogue].[1eH], [_Catalogue].[2eH], [_Catalogue].[3eH], [_Catalogue].[4eH], [_Catalogue].[5eH], [_Catalogue].[6eH], [_Catalogue].[7eH], [_Catalogue].[8eH], [_Catalogue].[9eH], [_Catalogue].[10eH], [_Catalogue].[11eH], [_Catalogue].Degré, [_Catalogue].Edition, [_Catalogue].[Etat dans la bibliothèque], [_Catalogue].Emplacement
FROM _Catalogue
WHERE ((([_Catalogue].Branche)=Forms!F_BrancheAnnee!cmbBranche) And ((([_Catalogue].[4eH])=Forms!F_BrancheAnnee!Cocher4)=True) And ((([_Catalogue].[5eH])=Forms!F_BrancheAnnee!Cocher5)=True) And ((([_Catalogue].[6eH])=Forms!F_BrancheAnnee!Cocher6)=True) And ((([_Catalogue].[7eH])=Forms!F_BrancheAnnee!Cocher7)=True) And ((([_Catalogue].[8eH])=Forms!F_BrancheAnnee!Cocher8)=True) And ((([_Catalogue].[9eH])=Forms!F_BrancheAnnee!Cocher9)=True) And ((([_Catalogue].[10eH])=Forms!F_BrancheAnnee!Cocher10)=True) And ((([_Catalogue].[11eH])=Forms!F_BrancheAnnee!Cocher11)=True) And ((([_Catalogue].[2eH])=Forms!F_BrancheAnnee!cocher2)=True) And ((([_Catalogue].[3eH])=Forms!F_BrancheAnnee!Cocher3)=True) And ((([_Catalogue].[1eH])=Forms!F_BrancheAnnee!cocher1)=True)); |
Partager