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!