Detail Report

[NLugo]

I would like to create a report that looks like an excel spreadsheet which will list the details as follows:
#of FT #ofPT Total
Company
Division I 2 1 3
Division II 0 1 1
Dept. 3 2 5
and so on...

I tried creating a pivot table but I have far too many columns and rows. Which is the best way to accomplish this? Any help would be appreciated.
Thank you

 

[Sohaila Taravati]

Use CrossTab Queries

 

[NLugo]

I tried creating a cross tab but I need some help. Is there somewhere I can go for samples?

 

[Rich]

Download the Querysamp from the MS knowledge base.