>Right.
>
>>I also think it needs to be grouped:
>>
>>>Try

SELECT Person.lname, Person.totassignhrs, SUM(Pinfo.totcomphrs),;
>>>  Person.failcmpldate;
>>> FROM  workprog!person INNER JOIN workprog!pinfo ;
>>>   ON  Person.personid = Pinfo.personid;
>>> WHERE NOT (Person.compstatus == "COMPLETE");
>>   <b>GROUP BY Person.personID ;</b>
>>>  <b>HAVING</b> SUM(Pinfo.totcomphrs) = Person.totassignhrs
>>>

>>>


Thank You, that worked and helped me out a lot.


Nick Patel