Mike,
(the UT just ate my last reply when I tried to post)
>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