Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angela - 20 Nov 2007 19:52 GMT

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

Reply to this Message

Jan Hyde (VB MVP) - 20 Dec 2007 13:14 GMT

Angela <Angela@discussions.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

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...