Posted by datagal on 03/08/06 23:56

This should do it...

select iwmsjn_Note
from [tablename] a
where iwmsjn_Timestamp = (select max(iwmsjn_Timestamp)
from [tablename] b
where a.[ID] = b.[ID])

Jody

[Back to original message]