Finding "highest" occurance

[HunterBoss]

I need to find the most recent instance of a client's order record and return only that one.

Order table could have zero, one or multiple (but more than likely never more than 50) order records. For those with multiple order records, I need to return only the most recent.

I can do the find based on just the client ID. That's the easy part. Based on other threads I've read, I see that the script can sort the found set. The part I'm confused about is how do I show just the first one?

Thanks

Christopher

[Zcast]

"I can do the find based on just the client ID. That's the easy part. Based on other threads I've read, I see that the script can sort the found set. The part I'm confused about is how do I show just the first one?"

Do you want the first one, or the most recent?

Since you can do the find based on client, just sort by order date using descending order. That will show you the "last, or most recent" order placed.

[Søren Dyhr]

Could it be something in the vicinity of this you're seeking?

http://www.kevinfrank.com/download/classroom-averages.zip

--sd

[HunterBoss]

That did it. A little tweak here and there but I'm certain this is what I'm looking for.

Thank you

Christopher