Query Parameters in a Report

[Carlo]

How do you get a query's parameters (i.e., start and end
dates) to appear in a report? I followed the instructions
per Knowledge Base Article 208630 but I had to input each
parameter twice--once to get the query to run and the
other to get the parameters into the report header. Is
there any way to do this where I only have to do this once
per parameter?

 

[fredg]

How do you get a query's parameters (i.e., start and end
dates) to appear in a report? I followed the instructions
per Knowledge Base Article 208630 but I had to input each
parameter twice--once to get the query to run and the
other to get the parameters into the report header. Is
there any way to do this where I only have to do this once
per parameter?

Carlo,

If the query parameter is something like:
Between [Start Date] and [End Date]

Add an unbound control to the Report Header.
Set the control source to:
= "For sales between " & [Start Date] " and " & [End Date]
The text within the brackets ([ ]) must be IDENTICAL to the text within
the query criteria.