Peter,

Thank-you for your solution. I really thought you had it.

Unfortunately, it only works because in Northwind all the orderID's are in the same sequence as the orderdate. So, having max on both gets you the 'correct' result. If you change the orderDate on 11070 to 04/23/98, then the result for item 1 is order 11070, (the max orderID containing item 1) and 04/24/98 (the max orderDate which happens to be on order 11047). This sadly, is the scenario that my data is in; my 'orderId' is assigned randomly instead of sequentially when compared with my 'OrderDate.

Gary