Hello all,
New member here and I need help.
I have two tables: Production and Disposition. Both tables have fields named date and Qty. I need to calculate first pass yield. Sounds simple enough until there are multiple entries for the same date. I've created a Query where I group production by date and have the criteria for example 6/26/2018. The issue is that I end up with a row for each production entry on 6/26/18 when I really need a total for that date. I have calculation in my query that is properly calculating FPY but its for each row of the same date entry in my table.
Here's some data:
Production table:
6/26/18 1000
6/26/18 5000
Disposition table
6/26/18 10
Calculation I'm expecting is 6000/6010. What I get in the query table view is one row of 1000/1010 and another row of 5000/5010.
Any ideas?
New member here and I need help.
I have two tables: Production and Disposition. Both tables have fields named date and Qty. I need to calculate first pass yield. Sounds simple enough until there are multiple entries for the same date. I've created a Query where I group production by date and have the criteria for example 6/26/2018. The issue is that I end up with a row for each production entry on 6/26/18 when I really need a total for that date. I have calculation in my query that is properly calculating FPY but its for each row of the same date entry in my table.
Here's some data:
Production table:
6/26/18 1000
6/26/18 5000
Disposition table
6/26/18 10
Calculation I'm expecting is 6000/6010. What I get in the query table view is one row of 1000/1010 and another row of 5000/5010.
Any ideas?