Hi Larry,
Yes, I agree and that's exacly what I said in my original message and
this is what puzzle me:
how comes it works perfect with
select * from temp group by clt_code,date
and not with
select * from temp group by date,clt_code
(..no no changing the name Date doesn't change anything)
Anyone can explain that?(Exception to David Bower who says it works with his Foxpro 2.6a - David I will
send you the code as soon as my email works - I cannot send for now)
(David Stevenson also suggested a nice workaround that has to be tried soon)
Réal
----------------------------------
>The following will group all the clients togther with there oldest account first. However, it will not display the client with oldest account first, if you want that, go with David's approach:
>
select * from temp group by clt_code, date
>
>The output looks like:
>1999.12.31 AA
>2000.12.31 AA
>1997.01.01 BBB
>2000.02.22 BBB
>1996.01.01 FFF
>1998.01.01 FFF
>1999.01.01 FFF
>2000.02.24 FFF
>
>Regards.