Need help with SQL statement

[EKC]

Hi,
I have table transaction with Parts and transaction dates.Each part has more then one transaction date of different type and source.My problem is that I need to get latest date for each part,so I'm trying with SQL statement(If It's possible?).If it's not possible how should I make small program to extract those latest dates.I know that it should be loop but how you do it?
Thanks for any help,
Cheers,
Lyn

 

[jonscott8]

SELECT PartNo, Max(TransDate) AS TransDate
FROM Transaction
GROUP BY PartNo Jon Hawkins

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed