I have a table in an Access 2007 database that contains the following fields: Emp. Name, Date Worked, a Yes/No field showing Paperwork received and a Yes/No field showing Paperwork Returned. I am trying to create a report that will be run for a selected month that has each day of the month as a column header and for each employee will have a row for days worked and will place a "Y" or check box in the columns that correspond with the days they worked. There will be 2 more rows for each employee that will place a "Y" or checkbox in the corresponding columns, one showing if Paperwork was received and one showing Paperwork Returned. I am new to Access and hopefuly I have given you enough information and a clear picture of what I am trying to achieve.
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!