Report Header/title from unmatched query

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

Jon M.

I am trying to create a report from an unmatched query. My query searches
records for students who have not taken a specific class. When you run the
query you enter the class# into a dialog box and the query runs. For example
for class# 313397 will display any students who have not taken that class.
How can I get the report to display the class# I am searching for unmatched
records on? What I mean is I would like my report title/header to be Class#
313397, and then list all the students who haven't taken it. My query
doesn't display the course I am searching for unmasked records for, it will
only display the courses the students have taken. As always I appreciate any
help anybody can offer! Thanks.
 
Copy the query criteria and paste in a blank field row of the query design
view grid and fill in alias like Search_Criteria: [Enter Class number]
where [Enter Class number] is the criteria.

Then Search_Criteria field will be available for use in the report.
 
Back
Top