Request name for report

[Guest]

Is it possible when I want to pull a report on a specific person or item to
have a field pop up for me to enter that information I am looking for. All
the information is setup in the database, however when I am ready to pull the
report I want it so it pulls a report on a specfic item. For example: If I am
keeping stats of a sales team, I would like to report to request the name of
the person.

 

[Guest]

You can have the prompt response also as output data.
Type the criteria prompt like this --
[Enter person for report]
Then copy and paste in the field row of the query design view like this --
Report Title: [Enter person for report]
Then when you use the query as your report source you will have the title.

 

[Guest]

Would it be the same process if I did not have a Query?

You can have the prompt response also as output data.
Type the criteria prompt like this --
[Enter person for report]
Then copy and paste in the field row of the query design view like this --
Report Title: [Enter person for report]
Then when you use the query as your report source you will have the title.
--
KARL DEWEY
Build a little - Test a little

Is it possible when I want to pull a report on a specific person or item to
have a field pop up for me to enter that information I am looking for. All
the information is setup in the database, however when I am ready to pull the
report I want it so it pulls a report on a specfic item. For example: If I am
keeping stats of a sales team, I would like to report to request the name of
the person.