I have an Access 2007 database that has 2 tables: 1st table is the Employee table that contains Employee ID, Employee Name, and the Location code they work at. 2nd table is the Work Log table that contains the Employee ID, date they worked, and 2 yes/no fields for paperwork received and paperwork returned. I need to create a form that lists all of the employees at a selected location that uses all of the dates for a given month as column headers. Under each column header that corresponds with a date the employee worked, I would like to have 2 check boxes for paperwork received and paperwork returned that can be edited so that those 2 values can be updated in the Work Log table. Is this possible and if so, how can I accomplish this? I am relatively new to Access.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!