Your report is called the CROSSTAB type.
You have to PIVOT the data.
In SQL Server 2000, you have to use the CASE function for pivoting:
Here is an example: http://www.sqlusa.com/bestpractices...thlypivot/
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!