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.
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.
Last edited: