Tamar,

That worked, but I also need to have the UCnCnMet.iOrder to be 1, I only need the first contact record for the patient.

Any idea how I can do this?

TIA

Rex

>>LEFT JOIN Impact!UCnCnMet ;
>> ON UCnCnMet.iContactId = UContact.iId ;
>>INNER JOIN Impact!SCntMeth ;
>> ON SCntMeth.iId = UCnCnMet.iContactMethodId ;
>
>You haven't said what results you're getting, but I suspect the problem is in the lines I quoted. Once you use an outer join, you generally need all the joins that follow it logically to be outer joins as well. Otherwise, the records that were added by the outer join get dropped by the subsequent joins because they don't match up to anything in the tables that are added in the later joins. Try changing the join with SCntMeth to a LEFT JOIN.
>
>Tamar