Capturing Query Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks Allen. I didn't realize that this information would come across like
that. I'll give it a try today (Friday).

Cheers,

Steve

Allen Browne said:
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.

SteveG said:
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
Click to expand...
Click to expand...
 
Back
Top