Last Price Paid on all Products List

  • Thread starter Thread starter Christine/Benton Co. Health Dept.
  • Start date Start date
C

Christine/Benton Co. Health Dept.

Anyone else have any other suggestions for my query
problem? I really appreciate this opportunity to learn
from this forum. Thanks so much for your help.

Subject: Re: Last Price Paid Query
From: "Christine" <[email protected]>
Sent: 9/30/2004 3:53:22 PM

That would work if I only wanted to query one item, but I
want to query all items for the last price paid so that
staff have a complete list of products to order from. I
do appreciate the quick reply though. This is only the
second time I've posted and the first time no one replied
to my question. So thank you!!!
 
Give this a try

Select A.Item, A.Price
From YourTable As A
Where A.OrderDate = (Select Max(OrderDate)
FromYourTable
Where Item = A.Item);
 
Back
Top