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.

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.