Display missing criteria in unmatched query

  • Thread starter Thread starter Jon M.
  • Start date Start date
J

Jon M.

I am running an unmatched queryfrom 2 tables that tells me which students
have not taken a particular class based on the class id. It is working fine,
but what I would like to do is display the class ID I am looking for in the
query results. So that if I search for students who haven't taken classA,
the query results will show me the student and ClassA. So far I can only get
the query to show me the classes they have taken. Is there a way to have the
missing criteria displayed in the results? Or in a report maybe? My ultimate
goal is to have a report where the class I am searching for missing records
on will be displayed as the header and the student list will be beneath. As
always any help is appreciated. Thanks.
 
Post the table structure, field names and datatype, where the classes are
recorded.
Post sample data.
Post what you would want the results to look like.
 
Back
Top