Show Paramater Entered for Report

  • Thread starter Thread starter Doctor
  • Start date Start date
D

Doctor

I have a report based on a Paramater Query. Is there a way to show on the
report what paramaters were entered to generate that report?
 
One way might be to include the field for which the parameter was entered.

If you want to see the selection criteria themselves, consider using a form
in which the parameters are entered/selected, then refer to that form and
those controls in the report itself.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Let me make sure I understand you. I can put to controls in a form (one for
each of the two paramaters that I want to select), fill those in, hit
"Search", and a subreport will generate the results the same way it does when
the subreport is based off of a select query instead of a Parameter Query?
 
I have a report based on a Paramater Query. Is there a way to show on the
report what paramaters were entered to generate that report?
Click to expand...

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
date]

The text within the brackets above must be identical to the bracketed
parameters in the query criteria.
 
Nope. What you described would leave Access "scratching its head".

Use a form, sure. But modify the query so it looks to the form to get its
parameters. Build your report on your query (which is now looking to the
form).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top