Can Parameter Value appear on a report?

[maura]

I have a report that is generated from a query that you enter the Start Date
and End Date. I am wondering if there is a way to get the Start Date and End
Date that a user puts in to print out on the report.

Is this possible, and then how do you do it (step by step instructions would
be terrific!) Thanks, maura.

 

[Douglas J. Steele]

Simply refer to [Start Date] and [End Date] in your report, such as putting
the following as the ControlSource for a text box:

="Details for transactions between " & [Start Date] & " and " & [End Date]

 

[maura]

Awesome!!! It works, it really works...

I added a text box with what you suggested (and it works!), but now when I
pull the report I am asked twice to put in the parameter values, why is that?

Thanks, m

Simply refer to [Start Date] and [End Date] in your report, such as putting
the following as the ControlSource for a text box:

="Details for transactions between " & [Start Date] & " and " & [End Date]

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have a report that is generated from a query that you enter the Start
Date
and End Date. I am wondering if there is a way to get the Start Date and
End
Date that a user puts in to print out on the report.

Is this possible, and then how do you do it (step by step instructions
would
be terrific!) Thanks, maura.

 

[Douglas J. Steele]

Make certain you type the reference to the parameter exactly the same in all
case.

Copy-and-paste is normally a good idea!

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Awesome!!! It works, it really works...

I added a text box with what you suggested (and it works!), but now when I
pull the report I am asked twice to put in the parameter values, why is
that?

Thanks, m

Simply refer to [Start Date] and [End Date] in your report, such as
putting
the following as the ControlSource for a text box:

="Details for transactions between " & [Start Date] & " and " & [End
Date]

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have a report that is generated from a query that you enter the Start
Date
and End Date. I am wondering if there is a way to get the Start Date
and
End
Date that a user puts in to print out on the report.

Is this possible, and then how do you do it (step by step instructions
would
be terrific!) Thanks, maura.