J
jopps
Hello,
I have tried to do this with Excel and just can't seem to get it and I am
relatively new at Access. We manufacture 10 different containers and build
about 10 per day. I add production runs to my build table, usually 100 at a
time per model starting on a certain date. I add orders on the order table.
When I add an order, I would like Access to tell me which Dates I should
expect these containers, based on Stock, Proction Runs and Previous orders
already entered. Here is what I have:
Table1_Products
Heading_Model
Heading_BuildPerDay
Table1_Orders
Heading_Model
Heading_CustomerName
Heading_QuantityOrdered
Heading_EstimatedShipDate (filled in automatically)
Table1_Build
Heading_Model
Heading_StartDate
Heading_QuantityToBuild
Would also like a reprt that shows Quantities on hand an Dates of Available
Quantities in Future
I hope this enough info. Thanks in advance for your time!
jopps
I have tried to do this with Excel and just can't seem to get it and I am
relatively new at Access. We manufacture 10 different containers and build
about 10 per day. I add production runs to my build table, usually 100 at a
time per model starting on a certain date. I add orders on the order table.
When I add an order, I would like Access to tell me which Dates I should
expect these containers, based on Stock, Proction Runs and Previous orders
already entered. Here is what I have:
Table1_Products
Heading_Model
Heading_BuildPerDay
Table1_Orders
Heading_Model
Heading_CustomerName
Heading_QuantityOrdered
Heading_EstimatedShipDate (filled in automatically)
Table1_Build
Heading_Model
Heading_StartDate
Heading_QuantityToBuild
Would also like a reprt that shows Quantities on hand an Dates of Available
Quantities in Future
I hope this enough info. Thanks in advance for your time!
jopps