How to get last record for each product

[Tompkins Neil]

Hi,

I have a list of product orders in a table with the following structure :

OrderID
ProductID
OrderDate
OrderCost

What query would I need to get the last order for each productID ?

Cheers,
Neil