P
Parker
I have Access 2000 database to track procuction runs. I
am trying to report on order costs (& profitability). The
problem I have is that we sometimes have 'stocked' items
and I want to add the average labor time for those
products to the appropriate production runs. Ex: We make
25 units on run #800 and put them into stock, the
production time is 25 hours - 1hr/unit. When we sell it,
we have a 'pull from stock' - run #850 that has no
production labor. I want to add the 1hr/unit. I have a
Query (QryOrderGP) that gives me all I need for the
standard stuff and I can make a Query to give me the
average times, but I want to limit it to stock runs that
were completed before the order shipped (A field in the
QryOrderGP Query). In the Example, if we make 25 more
units in 50 hours - 2hrs/unit, I don't want the average
time for previously completed runs to change to
1.5hrs/unit. Basically, I need to carry the completed
date to the new Query... Any thoughts on how best to
approach this?
Thanks in advance for any help.
Parker
am trying to report on order costs (& profitability). The
problem I have is that we sometimes have 'stocked' items
and I want to add the average labor time for those
products to the appropriate production runs. Ex: We make
25 units on run #800 and put them into stock, the
production time is 25 hours - 1hr/unit. When we sell it,
we have a 'pull from stock' - run #850 that has no
production labor. I want to add the 1hr/unit. I have a
Query (QryOrderGP) that gives me all I need for the
standard stuff and I can make a Query to give me the
average times, but I want to limit it to stock runs that
were completed before the order shipped (A field in the
QryOrderGP Query). In the Example, if we make 25 more
units in 50 hours - 2hrs/unit, I don't want the average
time for previously completed runs to change to
1.5hrs/unit. Basically, I need to carry the completed
date to the new Query... Any thoughts on how best to
approach this?
Thanks in advance for any help.
Parker