Report Header/title from unmatched query

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

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top