Re: Select record with highest value for field hours from multiple rows

DA Morgan wrote:

> This is clearly school work. Post your best attempt and we will give
> you pointers ... not solutions.

That may well be true, but I feel compelled to point out that I had a very similar requirement in the real world. (Although, I didn't solve it with a view. As part of a barcoding/job cost tracking system, the program mails appropriate managers when people obviously forget to clock out of a job - or, as happened recently, the UPS screws up and they can't clock out and no one has access to voice mail or email and...)

So do your schoolwork folks, don't expect usenet to bail you out! It pays off in the real world.

jg

--
@home.com is bogus.  "The sad truth is the job pays too well - I am an
Oracle whore and Larry is my pimp. In order for me to be truely happy
in my job I must master my fears and really get to grips with Oracle -
it's architecture and the strange gubbins inside the mysterious
machine." - Alan Barton