mmm, yes that seemed to work. letting user test it now. thank you.

Thanks for this. I was going nuts with syntax error until I saw your script that used th alias instead of the table name. Simple but brilliant!

thanks again.:-)

You guys are the best! The last post worked like a charm, not sure why other suggestions did not. You're absolutely right, the code is definitely klugy...you should see the...

Thanks for the great solutions, but none of them worked. I'm going to take the numerator and make 1 field and the divisor another field in a temp table, then...

now getting"invalid column commission cost"

any answers?

( I told you this would drive you mad!)

Thanks for any help

Emil

Not working for me...(big query here) is that the query name only or do I stick the whole query there?

I'm using sql 2000 btw.

Works! Thanks and Happy New Year.

sorry guys, I was in too much of a hurry.

Basically, Iwant to select the row with the latest order date for n rows with the same location_id, product_group_id and item_id....

Sorry, it didn't work. Still get:

item 1d fifo layer id

000497932

000496078

000491696

Any other...