huge brain-fart getting started here. Have weekly Excel file of sales by store by model as below:
Model, SOH, Sales, In Transit, Store
Have to add period(Yr,Month,Week#)to separate each weeks data.
When used Access Import wizard & split first file into linked tables: tbModel, tbStore, tbPeriod...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.