Access query show all dates (not in data) between start date and end date
Posted on 2008-11-10
Is there a way to show all the dates in between a start date and end (dates that are not in the data)? I would like this to be in a query.
What I am attempting is to show how many projects are being worked on per day, per person.
Here is a small example. The following person has 3 projects ranging from 10/10 - 10/27/08.
So, on 10/10, 10/11 and 10/12 there should be a count of 1; for 10/13, 10/14 and 10/15 there should be a count of 3;
for 10/16, 10/17 a count of 2;
for each date from 10/18 to 10/27 a count of 1.
Name Start Date End Date
Person1 10/13/0208 10/17/2008
Person1 10/13/2008 10/27/2008
Person1 10/10/2008 10/15/2008
Thanks for any help!!