I am planning an access tool that will both track historical information, and will aggregate information, and create a report for future availability and utilization of staff.
The tool will be executed on weekly basis, and each week the the weeks will change.
On a weekly basis, I will be importing data files, and I will need quries that will aggregate the data into one table.
i.e. this week the fields in the agregate are "
[Staff Member], Location, [Rank Desc], [12/5/2011], [12/12/2011], [12/19/2011], [12/26/2011], [1/2/2012], [1/9/2012], [1/16/2012], [1/23/2012], [1/30/2012], [2/6/2012], [2/13/2012], [2/20/2012], [2/27/2012], [3/5/2012], [3/12/2012], [3/19/2012], [3/26/2012], [4/2/2012], [4/9/2012], [4/16/2012], [4/23/2012], [4/30/2012], [5/7/2012], [5/14/2012], [5/21/2012], [5/28/2012], [6/4/2012], [6/11/2012], [6/18/2012], [6/25/2012], Total
next week the fields will be:
[Staff Member], Location, [Rank Desc], [12/12/2011], [12/19/2011], [12/26/2011], [1/2/2012], [1/9/2012], [1/16/2012], [1/23/2012], [1/30/2012], [2/6/2012], [2/13/2012], [2/20/2012], [2/27/2012], [3/5/2012], [3/12/2012], [3/19/2012], [3/26/2012], [4/2/2012], [4/9/2012], [4/16/2012], [4/23/2012], [4/30/2012], [5/7/2012], [5/14/2012], [5/21/2012], [5/28/2012], [6/4/2012], [6/11/2012], [6/18/2012], [6/25/2012], [7/2/2011], Total
Does anyone have a good recommandation on how to handle this in the smoothest possible way?
I appreciate the time you take to answer my question.
Regards,
Eyal
The tool will be executed on weekly basis, and each week the the weeks will change.
On a weekly basis, I will be importing data files, and I will need quries that will aggregate the data into one table.
i.e. this week the fields in the agregate are "
[Staff Member], Location, [Rank Desc], [12/5/2011], [12/12/2011], [12/19/2011], [12/26/2011], [1/2/2012], [1/9/2012], [1/16/2012], [1/23/2012], [1/30/2012], [2/6/2012], [2/13/2012], [2/20/2012], [2/27/2012], [3/5/2012], [3/12/2012], [3/19/2012], [3/26/2012], [4/2/2012], [4/9/2012], [4/16/2012], [4/23/2012], [4/30/2012], [5/7/2012], [5/14/2012], [5/21/2012], [5/28/2012], [6/4/2012], [6/11/2012], [6/18/2012], [6/25/2012], Total
next week the fields will be:
[Staff Member], Location, [Rank Desc], [12/12/2011], [12/19/2011], [12/26/2011], [1/2/2012], [1/9/2012], [1/16/2012], [1/23/2012], [1/30/2012], [2/6/2012], [2/13/2012], [2/20/2012], [2/27/2012], [3/5/2012], [3/12/2012], [3/19/2012], [3/26/2012], [4/2/2012], [4/9/2012], [4/16/2012], [4/23/2012], [4/30/2012], [5/7/2012], [5/14/2012], [5/21/2012], [5/28/2012], [6/4/2012], [6/11/2012], [6/18/2012], [6/25/2012], [7/2/2011], Total
Does anyone have a good recommandation on how to handle this in the smoothest possible way?
I appreciate the time you take to answer my question.
Regards,
Eyal
