I have a table of data that includes a date field showing when a task was completed. There is data for many users who may or may not have entered data for a particular day.
What I need to do is show by user ALL dates and the number of activities the user has completed. The problem is showing dates where no tasks have been completed. I need to show 0 for that day. As it is, the date is missing and averages are not being calculated properly on the report.
Is there a way to include all weekday dates using a SELECT even when there is no data for that date?
If more explanation is needed please let me know.