Display missing criteria in unmatched query

[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.

 

[Golfinray]

Try putting in the criteria field of the field Classes Taken, Is Not Null.

 

[KARL DEWEY]

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.