How do I get my report to ask for a paramater before it generates

M

MrsSmythe

I have a report that gives me a class list by Teacher, Period, Subject and
Student. Then I have to scroll through it toprint out one teachers list. How
can I get it to ask me for a teachers name and only generate thier schedule?
PS - This needs to be done with having my end user edit the query.
 
R

Rick B

In the query, under the teaher field, put something like...


Like "*" & [EnterPartialTeacherName] & "*"


Rick B
 
P

PC Datasheet

Base your report on a query that includes all the fields you need in a
schedule. Put the fo9llowing expressio in the criteria of the teacher field:
[Please Enter A Teacher's Name]
 
Top