Capturing Query Parameters

[Guest]

I've got a report I've built for a customer that runs a query that has 2
parameters which requires the user to input a start date and an end date.
The query runs correctly based on the user's date selections. How do I
capture the dates selected as parameters and include them in the overall
report? This way the user knows which dates they selected for the results
they see. I'd like them displayed in the report header for example.

Thanks in advance for any suggestions.

Steve

 

[Allen Browne]

The parameter names are available in the report.

For example, if you called the first parameter StartDate, you can add a text
box to the report and set its Control Source to:
=[StartDate]

More info:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

 

[Guest]

Thanks Allen. I didn't realize that this information would come across like
that. I'll give it a try today (Friday).

Cheers,

Steve

The parameter names are available in the report.

For example, if you called the first parameter StartDate, you can add a text
box to the report and set its Control Source to:
=[StartDate]

More info:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I've got a report I've built for a customer that runs a query that has 2
parameters which requires the user to input a start date and an end date.
The query runs correctly based on the user's date selections. How do I
capture the dates selected as parameters and include them in the overall
report? This way the user knows which dates they selected for the results
they see. I'd like them displayed in the report header for example.

Thanks in advance for any suggestions.

Steve