T
Ty Tyler
Hi all and thanks in advance.
I have a table of production data that is recording run date, press id,
operator name, shift id, start count, end count, good (net) copy count, hours
worked and various fields of down time items. I have built a query that will
do the math for a gross copy count (ending count from starting count), total
waste (net from gross) and average waste per job.
This works very well for a daily report.
What I can't figure out is how to sum those calculations for a weekly report
as it still lists every record that is within the date parameters asked in
the query.
I have a table of production data that is recording run date, press id,
operator name, shift id, start count, end count, good (net) copy count, hours
worked and various fields of down time items. I have built a query that will
do the math for a gross copy count (ending count from starting count), total
waste (net from gross) and average waste per job.
This works very well for a daily report.
What I can't figure out is how to sum those calculations for a weekly report
as it still lists every record that is within the date parameters asked in
the query.