Voici monSeigneur ...
SELECT Composant.pdtNom, nz([ComposeN1]![pdtNom],[Composant]![pdtnom]) AS ComposeNiv1, nz([composeN2]![pdtNom],[composeNiv1]) AS ComposeNiv2
FROM tblProduits AS ComposeN2...