Request name for report

G

gwtechie72

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

KARL DEWEY

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

gwtechie72

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

KARL DEWEY said:
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


gwtechie72 said:
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.
Click to expand...
Click to expand...
 
Top