Hi everyone: I have many 4 tables joined in to perform what a crosstab query would do in access. But I can not get it down in T_SQL which I need for ASP page to post on the web as a report. Does anyone have any good T-SQL statements for cross tabs or anything similiar to it. Thanks