Report totals

C

Custer

I am using MS Access for production reporting and I can seem to get some of
the field to total correctly!
There are several products run during a shift, and there is a standard for
each product. The shift data is stored in one table while the production
items is stored in a second table. The report is based on a query using both
tables. The shift data includes a counter reading which is total pieces
counted for that shift. The report calculates the standard pieces that should
have been produced based on how long each of the products is run. That total
is compared to the counter reading in order to get the efficiency for the
shift. The calulations and the counter reading is in the shift footer, which
works fine. Now I also need to calculate the daily total, and monthly total.
When I sum the counter in the day and month footer I get funny numbers. It
turns out that because the counter is in the query the value is repeated for
each product run during the shift. How can I get the counter and other
formulas to work correctly in the day and month footer?
 
Top