getting correct SUM results in a form

B

Bart

I have a form that is grouped by date, plantnumber and shiftnumber. we have 2
plants so on each day I get 2 reports one for plant one and one for plant 2
both with identical information. My report is complete but now I need to add
one more sum. Each plant has a TOTALUNIT for the day its in the shift
footer. I would like to keep at total for each plant total unit for the
month and total unit for the year. I have exhausted my trials and still just
get either a total for the day or have got a total for year but both plants
togather. should this be done in another query or can it be accomplished on
the report. thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top