Member Table

DepositAcct

LoanAcct

CreditCardAcct

 

All three tables contain the primary key of mb-num. I need to create a report that lis members that only have an deposit account = 00 and nothing else. I want to filter out all members who have active checking, loan, credit card and multiple savings accounts.

 

I can easily do individual reports on each table to show if a member has that account type (ie loan, checking, credit card) but i am not sure how to all four tables into one report so that it shows a true report of that one member type.

 

Thanks for any assistance.