I have a table that tracks client contact. I want to create a report
that checks to see if contact has been made in a specific month
(passed parameter). If no contact has been made for that month, then
display the client's name and move on to next client. I can do this
in other languages, but I cannot seem to figure it out in Access 2003.
On Oct 12, 10:31 am, "Mr. Ed"
> I have a table that tracks client contact. I want to create a report
> that checks to see if contact has been made in a specific month
> (passed parameter). If no contact has been made for that month, then
> display the client's name and move on to next client. I can do this
> in other languages, but I cannot seem to figure it out in Access 2003.
You first need to select the clients who have had contact in that
month, then use a subtractive filter to return the clients not
included in the above. Review the help file on subqueries.
General form of the query is
PARAMETERS [Month to report] as string;
SELECT ClientName from Clients WHERE ClientID NOT IN
(SELECT ClienfID FROM clientcontacts WHERE
Format( ContactDate."yyyymm") = [Month to report] );