View Single Post
  #5  
Old September 29th, 2004, 07:16 PM
rleblanc
external usenet poster
 
Posts: n/a
Default

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