>Hi
>I have a table with the following fields:
>

Area c(30) Date d and Quantity N(10,2)

>I have an sql statement that sums all quantities counts and groups by Area. I would like also, in the same sql statement, to have the Minimum and Maximum dates for every area. I don't know of any way of doing this, other than scan...endscan. Is this possible in a SQL Statement?
>
>Thx
>Jaime

Yes, it is possible to write that kind of statement. If I have 2-3 spare hours in the evening I can write it.