>>

SELECT CustomerID, MAX(DateTimeField) AS MaxDT FROM mytable GROUP BY CustomerID

>How does this ensure that it's the max/latest for a given Cust_ID?

Hi Terry,

The 'GROUP BY CustomerID' gives 1 record per CustomerID and 'MAX(DateTimeField)' returns the latest date for each CustomerID.