ms访问如何根据记录需求分配数量 [英] ms access how to distribute Quantity based on record needs

问题描述

例如：共有100个零件库存

并且有4个订单需要这个零件


订单1需要50到期5/26 / 2019

订单2需要30日到期6/1/2019

订单3需要40到期6/5/2019

订单4需要60将于6/10/2019到期


我可以做什么，所以我可以根据需要将总金额分配到每个订单，这样我就可以看到哪个订单会很短，什么时候做空。

如下所示


订单1需要50到期5/26/2019，数量在50，数量很短0
订单2需要30在2014年6月1日到期，数量在30，数量短0

订单3需要40到期6/5/2019，数量在20，数量短20

订单4需要60到期6/10/2019，数量为0，数量很短60


提前谢谢

for example: there total of 100 parts in stock
and there 4 orders need this part

order 1 need 50 due on 5/26/2019
order 2 need 30 due on 6/1/2019
order 3 need 40 due on 6/5/2019
order 4 need 60 due on 6/10/2019

what Can I do so I can distribute the total amount in to each order as need, so I can see which order is going to be short and when going to be short.
like below

order 1 need 50 due on 5/26/2019, qty in 50, qty short 0
order 2 need 30 due on 6/1/2019, qty in 30, qty short 0
order 3 need 40 due on 6/5/2019, qty in 20, qty short 20
order 4 need 60 due on 6/10/2019, qty in 0, qty short 60

Thank you in advance

推荐答案

嗯，您需要了解的第一件事是，只有在完全定义了您的要求后才能创建一个系统来反映您的要求。


在考虑如何设计之前，您需要决定如何分配项目。订单输入系统后是否会分配？它们是否仅在到期时才被分配？


这两种（非详尽的）示例方法中的每一种都有利有弊。你的工作是考虑这些并决定你想如何进行。当你到达那个阶段时，可能需要帮助来实现它，但我怀疑一旦你完成了必要的工作，你会更好地了解你正在处理什么，并且可能已经足够无需借助我们的帮助即可理解实施它。


显然，一旦你到了寻求帮助的阶段，那么请随时回来请求你需要。

Well, the first thing you need to understand is that you can only create a system to reflect your requirements when you have your requirements fully defined.

Before you consider how to design this you need to decide how you want items to be allocated. Do they get allocated once the order is entered onto the system? Do they get allocated only when they become due?

Each of these two (non-exhaustive) example approaches has pros and cons. Your job is to consider those and decide how you want to proceed. When you get to that stage it may be that you need help to make it happen, but I suspect once you''ve done that necessary work you''ll have a much better idea what you''re dealing with and probably have enough understanding to implement it without recourse to our assistance.

Obviously, once you get to the stage where it''s appropriate to ask for help then feel free to come back with a request if you need.

这篇关于ms访问如何根据记录需求分配数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！