Hello,
Is there a way to do this from a SQL View?
I have a table that has a beginning date and an ending date. What I want to do is count how many records are on each day. For example, Person A has a beginning date of 1/1/2005 and an ending date of 3/1/2005 and Person B has a beginning date of 2/1/2005 and an ending date of 4/1/2005.
I want a summary that like so:
1/1/2005 - 1
1/2/2005 - 1
...
2/1/2005 - 2
2/2/2005 - 2
...
3/2/2005 - 1
3/3/2005 - 1
Thanks for any suggestions!
MAC