TRANSFORM Sum(InventaireLocation.ILo_QteUnite) AS SumOfILo_QteUnite
SELECT InventaireLocation.Pro_NRI
FROM InventaireLocation INNER JOIN InventaireStatut ON InventaireLocation.InS_NRI = InventaireStatut.InS_NRI
GROUP BY InventaireLocation.Pro_NRI
PIVOT InventaireStatut.InS_Code

IS THERE A WAY TO DO CROSSTAB WITH SQL2000 (like this crosstab from Access)

Thanks

L-A