How to generate missing dates in SELECT?

Last Post 02 Dec 2008 09:27 AM by jgundrum. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
jgundrum
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.

Thanks,
John G.
You are not authorized to post a reply.

Acceptable Use Policy