Fred

Does the following work?:

Select MAX( DateTimeField) as Max_TF ;
  from MyTable ;
  Where CustID = lnChosenID
  into cursor csrMax
Select * from MyTable ;
  where DateTimeField = csrMax.Max_TF
  and CustID = lnChosenID

Terry
>Can anyone help me with an SQL Command that can extract the record with the latest DATETIME from a set of records that belong to the same Customer ID. I did it once but I cannot remember how.
>
>Regards
>Fred