Windows 7 64bit 
Access 2010 32bit
I'm looking for ideas for the most efficient way to build a database that will capture and report the daily status of workers. There are 50 workers and 3 status options for each worker. I'm looking to build a report that would then list the workers by their daily status (and then prints and/or emails the report, but that's another post). I started building something with a Table where each Field was a worker and a Form that had all the workers names (label) and a corresponding option group (buttons, to visually select one of the options), but it didn't feel like the right path and I couldn't find a way to setup the report to display the information correctly after the data was captured. Any direction or suggestions would be greatly appreciated.
# WORKER STATUS LogDate
1 Worker1 Option 1 09-09-21
2 Worker2 Option 1 09-09-21
.................................................. ........
50 Worker50 Option 3 09-09-21
REPORT
LogDate: 09-09-21
OPTION 1 OPTION 2
Worker 1 Worker 31
Worker 3 Worker 32
Worker 5 Worker 33
Worker 6 Worker 35
Worker 7 Worker 36
Worker 8
Worker 9
Worker 11 OPTION 3
Worker 21 Worker 30
Worker 22 Worker 49
Worker 24 Worker 50
Worker 35
Worker 44
Worker 45
Worker 47
Worker 48
Reply With Quote
Originally Posted by tiger6115
