I currently have set up two tables to track production. In the first table, I specify the production date. In the second related table, I enter the date as well as the output of the day. So in table one there is a single date but in table 2 there can be several records tied to the same date.
I am trying to write a report that will calculate the average output per day as well as for selected time period. The average per day is fine. However, when I try to sum up the total hours worked over the selected time period, it adds in the daily hours for each individual line item of output.
It is much easier to understand when you see the report. What is the best way to upload this information so it can be clearly understood?
Thanks,
Greg