Hello Again!!
I am hoping that someone can give a hand. I am trying to create a query that will pull info from a "Scheduling" table and a "Production" table. I've gotten this far. I wanted to have the difference calculated between the set scheduled production and the multiple inputs of actual production so that a running difference would be calculated. What I have achieved thus far is all save the running difference. Instead, I get the scheduled production placed against the multiple actual production entries, but the scheduled production is constantly refreshed to its original amount. For example, I schedule 1400 blue wheels on 9/12/03. I produced 500 on 9/13 and 500 on 9/14. My relationships are set to match the dates, product, and amounts. But I get 900 remaining on 9/12 and 900 remaining on 9/13. How can I have the totaled scheduled production to update dynamically as production is entered and achieve the running difference? I sincerely appreciate any and all help. Thanks.
I am hoping that someone can give a hand. I am trying to create a query that will pull info from a "Scheduling" table and a "Production" table. I've gotten this far. I wanted to have the difference calculated between the set scheduled production and the multiple inputs of actual production so that a running difference would be calculated. What I have achieved thus far is all save the running difference. Instead, I get the scheduled production placed against the multiple actual production entries, but the scheduled production is constantly refreshed to its original amount. For example, I schedule 1400 blue wheels on 9/12/03. I produced 500 on 9/13 and 500 on 9/14. My relationships are set to match the dates, product, and amounts. But I get 900 remaining on 9/12 and 900 remaining on 9/13. How can I have the totaled scheduled production to update dynamically as production is entered and achieve the running difference? I sincerely appreciate any and all help. Thanks.