How to generate missing dates in SELECT?

Last Post 02 Dec 2008 09:27 AM by jgundrum. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

02 Dec 2008 09:27 AM
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.

John G.

Acceptable Use Policy