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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.