sparky wrote:
> I have the following view, and would like to do a group by date to
> find out what is the current size of production. I can do the group
> by week (dt), but that returns 1 barn 7 times per week, so it sums it
> up 7 times. How can I do this group by and use the distinct to have
> only one barn per grouping?
>
> ID Barn_ID Size StartDate Received StartDate_p_Life dt
> 1 1 5000 08/02/2007 1 22/10/2007 10/18/2007
> 5 2 4000 17/10/2007 1 12/08/2008 10/18/2007
> 6 3 6000 15/05/2007 1 11/11/2007 10/18/2007
> 1 1 5000 08/02/2007 1 22/10/2007 10/19/2007
> 5 2 4000 17/10/2007 1 12/08/2008 10/19/2007
> 6 3 6000 15/05/2007 1 11/11/2007 10/19/2007
> 1 1 5000 08/02/2007 1 22/10/2007 10/20/2007
> 5 2 4000 17/10/2007 1 12/08/2008 10/20/2007
> 6 3 6000 15/05/2007 1 11/11/2007 10/20/2007
>
> maybe it's not even possible to use the distint - I can't quite figure
> it out.

Your description isn't that clear. Can you give a sample of your required
output from the above data.