Contact Management Database 1

[alljax]

I have a simple Contact Management Database that I have modified.
I am using this to manage mailings and calls.
I have created a table called 'Letters'
I have set a relationship between the letters and contacts as one to many, using the contact id as my primary key.(One contact can have multiple letters)
It is easy to build a query that will tell me which letters have been sent to contacts, but how do I query for contacts which have no record in the letters table.

I want to run a query that will tell me which contacts have not received letters and dump this into a report(actually a mail merge with Microsoft Office.

Any help appreciated.

 

[ZmrAbdulla]

It is difficult to say how to create a query without knowing your table set up.
Table Names, Field Names etc..

You can create a JOIN Query with both the tables then try changing the relation when you are at the design view of the query.

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[BobStubbs]

If you are in Access 2000 or later, try running the Find Unmatched Query Wizard. This will build a query for you, which will list records in your 'Contacts' table which have no related records in 'Letters'.

Once you have this query, you can modify it to suit your exact requirements.

I hope that this helps.


Bob Stubbs