Adfoka
06-28-2013, 11:27 PM
I have a small table where I record quantities ordered for few items.
I also have another table that shows availability over the next few weeks
I need to check quantities based on the entered date if the quantity will be available in the second table. If the requested quantity exceed the available for that week, then check if the remainder I available in the next week, if the remainder exceeds, then the following week and so on until the whole quantity is met. then auto generate the planned quantities over the next weeks
I attach an example .. I appreciate any help.. thanks
I also have another table that shows availability over the next few weeks
I need to check quantities based on the entered date if the quantity will be available in the second table. If the requested quantity exceed the available for that week, then check if the remainder I available in the next week, if the remainder exceeds, then the following week and so on until the whole quantity is met. then auto generate the planned quantities over the next weeks
I attach an example .. I appreciate any help.. thanks