Printing the "Perameter Settings" on a report

[shannaj via AccessMonster.com]

I have reports in which I pull from a range of Dates (Start Date and End Date)
I am wondering if there is a way to show on the report somewhere which
Dates have been selected? That way when I have printed off a report from
sometime in the previous week, I can look at it and know the date ranges that
I entered in. Is this possible?

 

[Allen Browne]

You can use the parameter names on the report, just as if they were fields.

For example, if you parameters are named [Start Date] and [End Date], you
could add a text box with Control Source of:
="From " & Format([Start Date], "Short Date") & " to " & Format([End
Date], "Short Date")

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

 

[shannaj via AccessMonster.com]

Wow! Thank you so much, that worked perfectly.

You can use the parameter names on the report, just as if they were fields.

For example, if you parameters are named [Start Date] and [End Date], you
could add a text box with Control Source of:
="From " & Format([Start Date], "Short Date") & " to " & Format([End
Date], "Short Date")

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

I have reports in which I pull from a range of Dates (Start Date and End
Date)

[quoted text clipped - 3 lines]

that
I entered in. Is this possible?