By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,882 Members | 2,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,882 IT Pros & Developers. It's quick & easy.

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

P: n/a
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!
Sep 17 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 16 Sep 2008 17:02:14 -0700 (PDT), sharsy
<sh***@ptpartners.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!
Sep 17 '08 #2

P: n/a
Perfect!!!
Sep 17 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.