Hi All
Was hoping to get some advise on a project i am doing for work. We're a retail business and report sales figures on a weekly basis.
at the moment the reports are generated in excel, and are very laborious!
I entend to have the following tables:
* Store
* Store Status (subdatasheet)
* Sales Info
the sales info will be downloaded from the accounts system and will show in the format of [Store] , [Sunday] , [Monday] , [Tuesday] , [Wednesday] , [Thursday] , [Friday] , [Saturday]
the store table is quite self explanitory - store id, name etc...
the store status table it will hold all records for the store status, ie, 01/01/01 the store was new, 01/01/02 the store becomes "like for like", and on 25/06/02 the store gets a refit.
the reports we generate are all based upon the stores status. so for example the report will show the current status for this week ie like for like, last week could be a refit - so will show on a seperate line.
in the cumulative section it may have a couple of weeks as new, a few weeks as like for like.
I've looked into the "top value" function, but that will only show the highest value? What i need is a top value as at a date, which can be changed to pull out different weeks...
Does anyone have any ideas on how this could be implemented??
Many Thanks
Dan