return latest date

[ajduk1]

Hi
I have a table "Stock delivery" that has the fields storesrefno, productname, productdescription, openingstock, qtyrecd, orderdate.
It may be that a storesrefno may have 2/3 orderdates against it,others may have none.How can I return all storesrefno's,(including the ones with no order date) but only the latest instance of an orderdate on the no's that do have a order date.
Thanks in advance
AJD

 

[jrbarnett]

select storesrefno, max (orderdate) as LatestOrderDate
from [Stock Delivery]
group by storesrefno

John

 

[ajduk1]

Thanks
worked a treat
again thanks for your time
AJD