Can Parameter Value appear on a report?

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

Guest

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.
 
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]
 
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

Douglas J. Steele said:
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)


maura said:
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.
Click to expand...
Click to expand...
 
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)


maura said:
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

Douglas J. Steele said:
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)


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