Hi folks

I am struggling with an update query.
What I need to do is group a [part code], select the latest available date then from that selection select the [lowest price] for each [part code]

[part code]
[date]
[lowest price]

Any one got any great ideas on where to start?

Stuart

I have no idea what you are asking.

You need to select a result set from a table and then from that resultset you need to select the latest available date and then from that result set you need the lowest price?

Is that correct?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

That is indeed correct.

So If I had this data....

sku1 21.00 09/10/2006
sku1 20.00 08/10/2006
sku1 19.00 08/10/2006
sku1 20.00 09/10/2006
sku2 31.00 09/10/2006
sku2 30.00 08/10/2006
sku2 29.00 08/10/2006
sku2 30.00 09/10/2006

--------------------------
I want this to update another table.

sku1 20.00 09/10/2006
sku2 30.00 09/10/2006

--------------------------

Sorry I did not explain well.

Stu