Reports to include names with no contact

[rcollins]

I have a report that gives me contact info for each client. We run these reports every month, ie, 4/1/2008-4/30/2008. As it is now we get the lients who have had contact for the month. What I would like to do is to have the clients with no contact listed too, or to have a list on the side who have no contact. I have made an find unmatched query, and do get the people who have never had a contact, but I am not sure how to incorporate this to use the start and end dates from another table. Here are the feilds I will be using from both tables:

Table Name=[[U]tblClient[/U]]
[I]Field;     Type;       IndexInfo[/I]
ID;        AutoNumber; PK
LastName;  String
FirstName; String
Active;    Boolean

Table Name=[[U]tblClientContact[/U]]
[I]Field;     Type;       IndexInfo[/I]
ID;        AutoNumber; PK
ClientID;  Numeric;    FK
Date;      Date/Time

Please help to point me in the right direction. Thanks

[NeoPa]

Please post in the two sets of SQL. First the one that has the selection by month, and then the unmatched query.

I'll then have what I need to incorporate both items into the one SQL query.

PS. I'll also have a better approximation of what you do & don't understand ;)

[nico5038]

Using the graphical query editor will make this easy.
Just pace both tables and drag and drop the ID field. (By default Access will already draw the line :-)
Now double click this line and chose option 2 (or 3) to make the clients table "
"leading".

That's all. You'll notice that the unmatched query does the same, but adds a Not Is Null criteria to "suppress" the ones that do have a value...

Nic;o)