How to extrct values from a parameter query to use in a rpt title

M

Mando

I am using a parameter query to create a report, the query uses a start date
and an end date to produce the data, I need to extract the values that I
entered into the parameter and use them as part of a title in a report, (ie
data from start_date to End_date), the start date and end date are the date
values I entered when I run the parameter query, which in turn is used to
produced the report. NEED HELP BIG TIME, THANKS!!
 
O

Ofer

If this is the record source of the report

Select * From TableName Where DateFieldName Between [Strat Date] And [And
Date]

Create a field in the report, and in it control source write
="Data from " & [Strat Date] & " to " & [And Date]
 
M

Marshall Barton

Mando said:
I am using a parameter query to create a report, the query uses a start date
and an end date to produce the data, I need to extract the values that I
entered into the parameter and use them as part of a title in a report, (ie
data from start_date to End_date), the start date and end date are the date
values I entered when I run the parameter query, which in turn is used to
produced the report. NEED HELP BIG TIME, THANKS!!
Click to expand...


Just use the parameters in a control source expression the
same way you would use any other field in the query. E.g.

="data from " & [start date] & " to " & [Enddate]

Make doubly sure that the references are spelled **exactly**
the same as in the query.
 
Top