>Sergey,
>I learned a lot from this exercise. I had to do some real head scratching for a while to get your solution to work on my data but I finally realized how it was meant to work. Definitely a eureka moment. I am determined to do things correctly going forward and that means learning a lot of new things.
Congratulations! I'm happy to see someone is willing to do the right thing.
>
>By the way, I never thanked you for the help last week so thanks for both.
>John.
>
>>John,
>>
>>Check
Re: SQL where clause for pulling latest date record. Thread #
1110024.
>>
>>>I need to find the employee id for the employee that has the most hours for each given work type.
>>>
>>>In VFP 6 the following SQL Select would work fine:
>>>
SELECT worktype, MAX(asgnhrs), emplid FROM john GROUP BY worktype
>>>
>>>In VFP 9 I am trying to do things the new way without useing the set enginebehavior 70 command. Of course this generates the "Invaid Group By" error becuase I have not included the emplid in the group by. But, if I did, I would get all the emplyees. What do I need to change to get only the emplyee id with the max hours?
>>>TIA.