I want to create a table within my database that shows the stock levels of the warehouse since time began (2010) - This should then update on a daily basis with any new information that comes in.
The data i have available to me is Volume Ordered/Sold (sold shown as a negative), Transaction Date, Product name.
What i need is a database that shows the stock level at 00:00 each day. In simple terms i believe this would be a cumulative sum entry for each day. (All the volume ordered to date - the volume sold to date = volume in stock at date)
I can't work out how to do this from referencing my other table - please help!
