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

G

Guest

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]
 

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

Similar Threads

Using VBA to alter a report 1
Help with the report needed 1
How to get two query results from one record 2
Why does my query ask for a paramater value? 7
Help to create a specific format for report 1
listings (records) in query 2
How do I auto populate fields in a form from information in anoth. 1
Query of 4 tables (control source) for a report - duplicates 2

Top