MS Access Need help building a report with two date queries
I have a report that looks like the following:
(List of employee's that are out) Date Employee
I would like to add to this report:
Date Employee Project
1-7-13 Patrick Window Replacement (this record = Date 1-7-13)
When I tried adding Project and Project due date to the query that supplies this report with a relationship - Project due date - Employee out Date:
I can only receive records if one date equals another. It will list properly on the report but it will not show all the records.
I would like to see all records of Employee's and Projects listed by one date on the left side of the report.