How to print a report's data horizontally

[Chaedar]

I have an "employee time sheet record" database. Its fields are: Date, EmployeeName, EmployeeNo, WorkHours.
I need to make a report that print the data horizontally, like this:
|------- D A T E ----------|
NAME EMP.NO. 1 2 3 4 5 ........31
Bob 12345 12 12 12 0 0 ..<- work hrs.
Ron 67890 0 0 12 12 12

Please help me how to make it.
Thank you for your help.
crendra@hotmail.com

 

[TracyF]

It sounds like you need a crosstab query. Check out what the help files tell you about it, then post back with any questions.