Dear All,
I am an Access beginner and desperately need some help.
I am trying to create a database which will show who is working on projects. The thing is, usually each person is involved in more than just one project, so I need to be able to show the, for example:
in August person X was allocated 10% on Project 1 and 80% on Project 1, which means that there is 10% available to be allocated elsewhere.
I'd need my reports to look more less like the attached example.
The problem I have is I have no clue as to how to show person’s monthly allocation in %. Do I need and extra table for year 2010, where each entry would be a month to be filled in with % and then make and relationship to a person?
Please, could you enlighten me?
Thank you in advance!
Aneta