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!!!