I am new to Access and I have an Access 2007 database that has a table that has the following fields: Employee Name, Date Worked, Yes/No for Paperwork Received and Yes/No for Paperwork Returned. Is it possible to create a query that I can run a report off of that will show one row for each employee, for each day of a selected month, a Y/N field showing if the employee worked that day, if the paperwork was received, and if the paperwork was returned based on the information in the table. Sort of like a pivot table or crosstab query. For example the table looks like this:
Employee Date Worked Received Returned
Joe Blow 4/1/2014 Y N
Joe Blow 4/2/2014 Y Y
Joe Blow 4/4/2014 N N
Joe Blow 4/21/2014 Y Y
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!