Thanks for your quick reply!

I'm trying to get the last order (max(orderdate) for each item. Ultimately, I'm building a separate association table between products and orders using only the latest order. We are doing a conversion and the structure of my actual tables is the same as in the Northwind. In my case the last 'order' is current and all the others are actually historical and can be ignored (at least for this association). I'm selecting a category here to simulate the criteria for the 'products' subset that I need.

Gary