Inge,

Try this

Select field1, max(date) ;
   from mytable ;
   group by field1

Scott

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