MS Access Need help designing a weekly user project input
Posted on 2013-05-22
I have a Access database of projects with users assigned to them, and would like the users to input what projects there working every week.
The goal is for the manager to view what the users are currently working on (current week), and to provide a report for how many weeks the user worked on that project.
How should the user input this information? Table structure?
(date range wouldn't work due to the project is not worked on consecutively)