Just to let you know your solution worked perfectly. thank you

Many thanks for your reply. I am still new to this so I will work through what you gave me and let you know how it goes.

Thanks again

It's basically an inventory control/forecasting process. The data you gave is correct but I do not know how to produce the data on a daily basis.

I have a web application,...