Staff Forecasting

[RobinK]

I'm using Access 2003. I'm not sure how to word this or even search to see
if it's been posted, so here goes.

I'm creating a staff planning database for our project managers. To begin
with, they will enter the weekly forecasted hours for a given employee for 20
weeks, for all projects. Then, once a week thereafter, they will enter the
forecased hours for week 21. Each week the 20-week span will adjust out
accordingly (week 1 will be hidden and week 21 will be added, then the next
week weeks 1 and 2 will be hidden and week 22 will be added, etc.). All
values need to be maintained for multiple report formats.

Ultimately, each employee will have hours for an infinite number of weeks.
So far, I have a Project table and an Employee table. The Employee table has
the employee name, week beginning, and hours.

This is what the resulting form 'should' look like:

Project A
Week 1 Week 2 Week 3 ....
Emp1 40 23 12
Emp2 10 3 7

Project B
Week 1 Week 2 Week 3 ....
Emp1 20 2 10
Emp2 6 1 5

How the heck do you set this up? I creating a cross-tab form, but couldn't
figure out how to automatically include fields for an infinite number of
weeks.

Can you point me in the right direction?

Thanks in advance.

 

[Peter Hibbs]

Robin,

One way to display the information on screen would be to use a
FlexGrid control but you will need to do some serious VBA coding. If
you can handle this have a look at the demo program at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

HTH

Peter Hibbs.