Printing parameters on report

[betheball]

I have a report based on a query. The query returns records from a date range. So, when I generate my report, I am first asked the from and to dates. How do I make these dates appear on my report? Somewhere in the header or footer I want to display the parameters.

 

[Graham T]

How to Print Parameters onto your report:

If you've based a report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and specify the parameter by name as the control's Control Source using the form

=Reports![reportname]![parametername]

Let's suppose you want to add the feature to a report named rptHolidayRequests and your query's parameter is Between [Enter Start Date] And [Enter End Date]. In this case, you'd enter the expressions of

=Reports![rptHolidayRequests]![Enter Start Date]

=Reports![rptHolidayRequests]![Enter End Date]

HTH

Graham

 

[betheball]

Thanks Graham. That works great. One dumb question: What does HTH mean?

 

[Graham T]

Hope this helps....

Which luckily it did !!

Graham