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?

date: Tue, 20 Nov 2007 11:52:00 -0800   author:   Angela

Re: Query   

Angela '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

date: Thu, 20 Dec 2007 13:14:02 +0000   author:   Jan Hyde (VB MVP)