newbie report question

  • Thread starter Thread starter Samuel
  • Start date Start date
S

Samuel

Hi everyone,

I have a report that is based on a parameterised query that user inputs when
generating the report

I would like this report to include the actual parameters' values

Thank you,
Samuel
 
You can add a textbox to your report, and set the control source to repeat *exactly* the parameter prompts. For example if your query has [Enter City], then put a textbox on the report with
=[Enter City]
in it. You can embellish with additional text like
="Summary for " & [Enter City]
 
Create a field on your report which has the control source the same as your
parameter: e.g.

=[Forms]![myForm]![myParameter1] from a form;
Give it a name that does not match any other fields returned from your
report control source query, e.g. searchParameter1.
You can do as many of these as there are parameters, and even concatenate
them for a better report design.

Or if you are prompting for the parameter from the query
=[Enter First Parameter] (i.e. exactly as it appears in the query)

Mich
 
Back
Top