help with report

[axle124]

First I am trying to get a report to print production and non production hours for a month.

I have my query giving me the right total as far as that goes, but the way I did it was to have a sum for a week with weekending date. It totals the hours for that week and I did that four times, but I want my query when called to already know that my 3 other dates are 7 days below each other. This totals all hours no matter what class they are in.

I would like to print a report that totals the hours at the end of the report for non production and production hours ie:

Total hours 2000 3000 2100 2800
production hours 1800 2800 1800 2500
non production hours 200 200 300 300


i Know this is vague, but i would apprectiate any help

Brandon

 

[axle124]

I have a query that figures a weeks worth of hours by days, and then I add those together to get my total for the week. So if i worked 8 hours a day for 5 days, my query will put my hours under the correct day as long as it is within my 7 day parameter of the weekending date. Now I need to figure a Monthes worth of hours and put them under the correct classification which is either production or non production. I can do this if i do the same query that i did for my week and copy 3 other times, but it asks me for 4 weekending dates and i want it to already know the other dates. I can not seperate the production and nonproduction hours without doing 2 seperate queries. I should be able to seperate this at the report level should I not.