Salut et bonne année, on ce qui conserne ta 1ere question la structure de la requete peut être comme suit: SELECT ...,IIF(taux = 6,SUM(montant),0) as montant1,; IIF(taux =18,SUM(montant),0) as montant2,; IIF(taux =10,SUM(montant),0) as montant3,; IIF(taux=18.5,SUM(montant),0) as montant4; FROM ... GROUP BY taux,montant ... ta 2ème Question : INSERT INTO <nom dbf > [(<champ1>[, <champ 2>[, ...]])] VALUES (<expr1>[, <expr2>[, ...]]) ----- [(<champ1>[, <champ 2>[, ...]])] facultatif VALUES obligatoires
|