>>GROUP BY 2?
>>How could you GROUP by MAX(...)?
>
>Oops, it was untested, of course. :-) Should be GROUP BY 1, but I like your solution better.
:o)
I was sure about it.
Unfortunately my solution would works only with VFP9. No derived tables in previous versions.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.