Query filter - Joined Tables - Want to find people with no records onsecond table

[sharsy]

Hello,

I have a Database setup that has two tables that are linked. Table1
contains a list of people with their basic contact details (name &
phone number etc.) and Table2 contains a list of all marketing calls
made to the people on Table1. The tables are linked via an ID # field.

What I would like to create is a query that shows all contacts on
Table1 who we have not made a call to. The problem I'm experiencing is
that as these people have never been called, they don't have any
records (calls) on Table2. I'm struggling to find a filter that will
filter out people who have records on Table2 from my query.

Does nayone know how I can fix this?

Thank you!

[Tom van Stiphout]

Re: Query filter - Joined Tables - Want to find people with no records on second table

On Tue, 16 Sep 2008 17:02:14 -0700 (PDT), sharsy
<shari@ptpartne rs.net.auwrote:

Classic problem. Here is how to proceed: create your query with the
two tables. Right-click the link between them and choose the option
"include all records from Table1 and ...."
Then on the ID field from Table2, set a criterion of "IS NULL".

-Tom.
Microsoft Access MVP

>Hello,
>
>I have a Database setup that has two tables that are linked. Table1
>contains a list of people with their basic contact details (name &
>phone number etc.) and Table2 contains a list of all marketing calls
>made to the people on Table1. The tables are linked via an ID # field.
>
>What I would like to create is a query that shows all contacts on
>Table1 who we have not made a call to. The problem I'm experiencing is
>that as these people have never been called, they don't have any
>records (calls) on Table2. I'm struggling to find a filter that will
>filter out people who have records on Table2 from my query.
>
>Does nayone know how I can fix this?
>
>Thank you!

[sharsy]

Re: Query filter - Joined Tables - Want to find people with norecords on second table

Perfect!!!