Search results

Thanks for the reply. That seems to be what I need. This database is used for scheduling so people may not end up working exactly as allocated but it allows us to predict costs, sometimes months in advance. Just to clarify, option 4 will automatically populate a table based on the start and...

Thanks for your response. I have changed the Person ID to SAP ID to match the timesheets table. We measure people’s time as a percentage. 100% corresponds to a person’s full time, so each person should not have more or less than 100% allocated at any one time. Projects can have more than 1...

Hi All, I am new to access but am trying to get to grips with it as it could help me solve some problems at work! I am trying to create an access database to allocate people to projects and show the total time spent on projects. As peoples time can be allocated to different projects I want...