Using LAST in Grouped Queries

[LeanneGodney]

Hi there,

In my table I have lots of trade documents stored per trade. Each document has a set of properties, including a comments field. I would like to see the most recent comment field, be it the most recently added or the most recently edited.

In Access you could group the data and specify LAST for the comments field, and GROUP BY for the Trade's Ref.

Is there something like this in SQL Server queries? Or should I start using a time stamp for the comments field?

Thanks,
Leanne