parameter querys and reports

[Alex Brown]

I have a table which has the list of students in a school. I have another
index table with id numbers and the name for each academic department in the
school. I have one more table which has the ID for the department, along
with the classrooms which correspond to each department. Now what I want to
do is print a report which shows the names of each student in every
classroom for one particular department. This is what I did:
I made a query with my two indexes so that I would have a query which shows
Id for academic department, name of academic department, and one classroom,
there is one record per classroom.

I then made another query joining my StudentTable and my newly made query on
Classroom, and placed an extra field in the query, which wasnt visible,
corresponding to the academic department Id, and had the criteria set to a
parameter [Enter Department ID]

I then made a report based on this final query. Everything works fine...
the problem is, the title that gets printed on the report is just "Students
by Department". What I would like, is based on the parameter inputed when I
open the report, is the title to change to something like "Students in the
Math Department" or something like that which corresponds to each academic
department. Can anybody help?

 

[Steve Schapel]

Alex,

Have you included the [name for each academic department] field in your
query? If so, put an unbound textbox in the header section of your
report, and set its Control Source property to...
="Students in the " & [name for each academic department] & " Department"

 

[Alex Brown]

I have not... but I will and that should work... thanks...

P.D. what I ended up doing is taking off the parameter query, and change the
onOpen event, then have an Input Box which takes the Department ID number,
then use a Select Case statement for each department where I set a filter,
and set the caption for the label....

However I think your way is probably easier...