>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