Printing 'Not Responded" records

  • Thread starter Thread starter Mike C.
  • Start date Start date
M

Mike C.

Hello.

I have a database that tracks the responses of a number of
agencies - about 40. Basically, a request for information
is sent to the agencies and their respose is inputed into
the database - one record for each agency.

The names of the agencies are alreay in a table in the
database and a form contains a drop down box of all the
agencies' names. Once one has responded, their info is
put into the database.

I want to generate a report that tells which agencies HAVE
NOT yet responded. Is this possible and if so, how?

Any help would be appreciated.

Thanks in advance,

m.
 
Mike said:
I have a database that tracks the responses of a number of
agencies - about 40. Basically, a request for information
is sent to the agencies and their respose is inputed into
the database - one record for each agency.

The names of the agencies are alreay in a table in the
database and a form contains a drop down box of all the
agencies' names. Once one has responded, their info is
put into the database.

I want to generate a report that tells which agencies HAVE
NOT yet responded. Is this possible and if so, how?
Click to expand...


Set the report's RecordSource query to something like:

SELECT Agencies.AgencyName
FROM Agencies LEFT JOIN Responses
WHERE Responses.Response Is Null
 
You could use a query where you set the filter to response
is null. Without knowing specifically how you have your
data tables/queries set up I can not give you more
specific information.
Hope this helps.
Fons
 
Back
Top