By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,473 Members | 3,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,473 IT Pros & Developers. It's quick & easy.

Display Records Not Found

P: n/a
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.

Oct 12 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Oct 12, 10:31 am, "Mr. Ed" <gog...@yahoo.comwrote:
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] );

Oct 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.