Even simplier

SELECT field1, MAX(date) ;
        FROM mytable GROUP BY field1 

>Try

Select field1, date ;
>  FROM mytable ;
>  WHERE field1 + DTOS(date) IN ( ;
>    SELECT field1 + DTOS(MAX(date)) ;
>        FROM mytable GROUP BY field1 )
>

>
>>field1, date
>>campbell,10/01/01
>>campbell,9/8/00
>>cristy,5/1/00
>>cristy,2/2/01
>>
>>I need SQL select statement that will give me only 1 record per field1, but with the latest date:
>>campbell, 10/01/01
>>cristy 2/2/01
>>
>>CAN ANYBODY HELP????
>>Thank you all!!!