Pat,
Thank you for the reply. I thought I understood what you were saying however, when I try to make it work I still get the same results as I did with my previous query. The new query looks like:
SELECT tblBusinessPartnerXref.CustCodePartner1, tblBusinessPartnerXref.CustSuffixPartner1...