Windows 7 32bit 
Access 2010 32bit
Newbie here.Thankyou to all who post solutions to issues over the years.Using that information and tweaking it forour own use, we’ve been able to build a “good sized” database.We are now looking to do something a littlemore complicated. Every week, we purchase “widgets”.The number purchased varies each and everyweek.The vendors the widgets arepurchased from varies week by week.We thenhold the widgets for a few weeks in order to do some processing before weresell them.We typically start resellingthem 20 weeks after purchase.We projectwe will sell a percentage during week 20, another percentage during week 21,etc.The following chart outlines ourtypical patterns.
Week In Processing Week 20 Week 21 Week 22 Week 23 Week 24 Week 25 Week 26 Week 27 Week 1 10% 20% 20% 20% 30% Week 2 10% 20% 20% 20% 30% Week 3 10% 20% 20% 20% 30% Week 4 10% 20% 20% 20% 30% Week 5 10% 20% 20% 20% 20%
As you can see, at times we may be able to purchase widgetsthat don’t need as much time/processing to those widgets.We may purchase them in Week 5 but only need15 weeks of processing so we can start selling them in Week 20.
We “simply” want to add up all the projected sales for eachweek in the future.We will create areport to give to the sales staff so they can plan ahead.
I currently have all the purchases in a table.Each purchase is listed individually withtheir DateArrived.Each purchase has additionalinformation also in that table that is sorted or queried for other reports.
Reply With Quote
