Query

I've 3 columns with customerID, orderDate and Quantity. How do I obtain a
list of customers with the last (maximum) orderDate and Quantity?

Angela <Angela (AT) discussions (DOT) microsoft.com>'s wild thoughts
were released on Tue, 20 Nov 2007 11:52:00 -0800 bearing the
following fruit:

I've 3 columns with customerID, orderDate and Quantity. How do I obtain a
list of customers with the last (maximum) orderDate and Quantity?

Do you want the last (maximum) entry for each customer, or
only customers with an order date that matches the last
(maximum) order date on the system?


--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde