I need to fill in some missing dates. I created a table with the dates but it doesn't seem to work. I need to be able to filter the report by staff member and once I do all the extra dates are eliminated.
This is what it shows when I filter it by date on the table i created.
Date Table: 1/1/2016
Date Table: 1/2/2016
Date Table: 1/3/2016
Date Table: 1/4/2016
Date Table: 1/5/2016
This is what I see when I filter it based on employee who had entries only the database (which is different from the table i created) for the 1st and 3rd
Date Table: 1/2/2016
Date Table: 1/4/2016
Date Table: 1/5/2016
Even though those dates are from the table i created which has all the dates. It still excludes the dates that the employee didn't have entries on. I need to also show the dates for the days they had no entries.
What am I doing wrong?
Thanks