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=[tblClient]
- Field; Type; IndexInfo
-
ID; AutoNumber; PK
-
LastName; String
-
FirstName; String
-
Active; Boolean
- Table Name=[tblClientContact]
- Field; Type; IndexInfo
-
ID; AutoNumber; PK
-
ClientID; Numeric; FK
-
Date; Date/Time
Please help to point me in the right direction. Thanks