T
tsison7
I have a query which gathers a product list from an imported ship history
table. To do this I use a group by on [ProdID] and Max on [ShipDate] and
[UnitPrice].
My problem is this makes a list where the last Ship Date is obtained and the
highest price is listed. Instead I would like it to list the Unit Price
associated with the Ship Date (ie. the last shipment price)
How would I do this?
table. To do this I use a group by on [ProdID] and Max on [ShipDate] and
[UnitPrice].
My problem is this makes a list where the last Ship Date is obtained and the
highest price is listed. Instead I would like it to list the Unit Price
associated with the Ship Date (ie. the last shipment price)
How would I do this?