query excluding listings from table

[Mary]

I am wondering if it is possible to do a query which checks a table and
excludes all listings from that table.

I have a table with members and their addresses.
I have another table with a listing of group homes.

Is it possible to tell a query to check the table of group homes and exclude
all members with addresses that are in the group home table?

For example:
In member name and address table:
[MemberName] "John Doe"
[AddressLine1] "Peaceful Pines"
[AddressLine2] "1234 Any Street"
[CityStateZip] "Anywhere"
[Country] "USA"

In group home table:
[Group Home] "Peaceful Pines"; "Pleasant Plateau"; "Restful Abode"

Can a query for address labels check for the listings in the group home
table and exclude "John Doe" because he lives in "Peaceful Pines"?

I have been excluding these homes by typing them into the query as
Not Like
But it's a hassle to maintain as they can change, I'd like the query to
check the table and leave out these buildings.

Thank you ahead of time for your help.

 

[SuzyQ]

do a left or right join (in design view the arrow should point to the Group
table)
Select the key field from the group table as one of the fields in the query
and use the criteria of is null.

 

[Mary]

Thank you so much, it worked like a charm.

do a left or right join (in design view the arrow should point to the Group
table)
Select the key field from the group table as one of the fields in the query
and use the criteria of is null.

I am wondering if it is possible to do a query which checks a table and
excludes all listings from that table.

I have a table with members and their addresses.
I have another table with a listing of group homes.

Is it possible to tell a query to check the table of group homes and exclude
all members with addresses that are in the group home table?

For example:
In member name and address table:
[MemberName] "John Doe"
[AddressLine1] "Peaceful Pines"
[AddressLine2] "1234 Any Street"
[CityStateZip] "Anywhere"
[Country] "USA"

In group home table:
[Group Home] "Peaceful Pines"; "Pleasant Plateau"; "Restful Abode"

Can a query for address labels check for the listings in the group home
table and exclude "John Doe" because he lives in "Peaceful Pines"?

I have been excluding these homes by typing them into the query as
Not Like
But it's a hassle to maintain as they can change, I'd like the query to
check the table and leave out these buildings.

Thank you ahead of time for your help.