Showing query criteria in report

[Guest]

Hi!

I have created a number of reports, but i have not included the field where
the criteria is input into the query.

Example:

My query is 'Enter an ID'...but i haven't put this field into the report, I
have not decided that I would like this field to be shown in the report at
the top or the bottom. Is it possible to do this without implementing the
reports from the start again, because i have about 15 reports that i need to
change, which took about 30 mins to create each! I want the criteria that is
input into the query, to be shown on the report.

Please help!
Thank you in advance!

Emma

 

[Duane Hookom]

You should avoid using parameter prompt queries. You are much better off
referencing controls on forms.

You can get the value of the entered parameter by adding a text box with a
control source the same as your parameter:

=[Enter an ID]

 

[Guest]

Emma,
Check out the demo in www.joshdev.com Report Navigator, it shows how to
display the filter in a report