SQL Help?

[JHausmann]

SQL server has a "Cube" and "rollup" statment I've never used...

I'd like to report across on items in an access 97 database... I'm using Data environments and dataReports OLE objects in VB v.6.0

instead of

empno1 empname1 day1 day2 day3 day4 day5
empno2 empname2 day1 day2 day3 day4 day5
empno3 empname3 day1 day2 day3 day4 day5
empno4 empname4 day1 day2 day3 day4 day5
empno5 empname5 day1 day2 day3 day4 day5
(acceess table structure)

I'd like to list it like :

Empno1 Empno2 Empno3 Empno4 Empno5
______ ______ ______ ______ ______
day1 day1 day1 day1 day1
day2 day2 day2 day2 day2
day3 day3 day3 day3 day3
day4 day4 day4 day4 day4
day5 day5 day5 day5 day5

Any ideas, I believe a SQL statement can handle this, I just don't know the syntax....

Please Help....

Thanks a million,,,

Marc