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...