Hi all,
I have a query that gets daily hrs worked by employee from a Staff Hours table. The query pulls these fields from table by input date range. Date, EmployeeID, Name, Dept#, WorkHrs, OtherHrs, TotalHrs,. My question is how can I create a report with similar layout as follows. I've attached a word document showing the proposed report layout in case the one below doesn't maintain it's format when posted.

Mon Tue
Name ID Dept# Workhrs,OtherHrs,TotalHrs WorkHrs,OtherHrs
joe 3 12 7 7 7
jim 4 11 8 8 7

Hope anyone can understand what I'm trying for. The days will continue across to SUNDAY followed by TOTALS for week with two added fields in totals for calculating Straight OT and Premium OT.
Please, I really need help in getting a report with this layout. Is there something I should do at the query level that would make it easier.

Thanks in advance

Rory
Sorry about that everyone, it seems the sample layout above looks good in original message looks ok but everything falls to the right margin when message is posted. and i can't see the word file I attached. I'll try again later.

Put your template between [(space)code(space)]
and
[/(space)code(space)]
to preserve some formatting

You can do it by creating 5 crosstabs. One for each hours figure - Workhrs,OtherHrs,TotalHrs WorkHrs,OtherHrs. Then a final query that joins the 5 crosstabs on ID. Make sure that you fix the columns of the crosstabs in case there are any missing days in your data.