Ok you'd create a query with both tables and then join them by the Primary
Key like member ID then you'd double click on the join line and select the
statment that said something like:

"Include ALL records from tblClub and only those records from tblCommunity
where the joined fields are equal."

Then you'd bring down all the fields that are relevent to tblCommunity to
the field listing and you'd bring down the MemberID from tblClub and add the
Criteria "Is Null"

Here is an example of what the resulting SQL would be:

SELECT tblClub.FName, tblClub.LName
FROM tblClub LEFT JOIN tblCommunity ON tblClub.MemberID =
tblCommunity.MemberID
WHERE tblCommunity.MemberID Is Null;

Hope that helps...

There is an "Unmatched Query Wizard" which will do just this; create a
new query and select that wizard.

                 John W. Vinson[MVP]