hello, I'm not sure if this is a query or report question, but here goes. I'm trying to make a report that has labor hours totals for the week and also a running total. I'm working with two fields OT and DT from tblEmployeeHours. I wanted the report to have the labor presented left to right with column headings designating the dates. I can create a query(actually 3 built on top of each other as I wasn't sure how to Sum the totals) that will give me the totals. I also created a crosstab query that will give me totals but I can't apply criteria to it. The other query pulls back daily info. When I try to create a report my information(the dates) is displayed in rows. I suppose this is because I grouped on the employee name. Any ideas on a better method. I don't think I'm doing this right. Can I create one query to return the running totals(for labor hours) and also the daily(labor hours)?
Thanks,
Jim
Thanks,
Jim