>>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.
>>
>
SELECT CustomerID, MAX(DateTimeField) AS MaxDT FROM mytable GROUP BY CustomerID
Sergey
How does this ensure that it's the max/latest for a given Cust_ID?
Terry
- 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.