Thanks! This works great!
I just set up two text control boxes, and used the lables for the text box
for text as follows:
From start date: mm/dd/yyyy to: mm/dd/yyyy
And put "StartDate" and "EndDate" in the text boxes themselves. This worked
out perfectly!
Thanks again!
"AlCamp" wrote in message
...
You can refer to the parameter values on a report by just using the
parameter...
In this case the [Start Date] parameter can be displayed on the report
by
using a control with = [Start Date].
Or concatenate for a better look...
= "Between " & [Start Date] " and " & [End Date]
would display as Between 1/1/04 and 2/1/04
Use them just like a table field...
hth
Al Camp
"rleblanc" noone@somewhere wrote in message
...
I have several reports which ask for a "Start Date" and an "End Date" for
use in determining the period of time the report is to show data for.
For
this I use the "Between" and "and" function to request from the user what
period of time to display data for.
However, I would like to be able to show at the top of the report the
period
covered by the report such as:
Report for start date: mm/dd/yyyy to: mm/dd/yyyy
How do I access the "Start Date" and "End Date" which were entered as
part
of a select query? Does Access have a special name for these values? How
can
these parameters be accessed for use in the report?
Thanks
|