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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mando - 02 Feb 2006 22:41 GMT

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!!

Reply to this Message

Ofer - 02 Feb 2006 23:11 GMT

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]

Signature

\\// Live Long and Prosper \\//
BS"D

> 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!!

Reply to this Message

Marshall Barton - 02 Feb 2006 23:15 GMT

>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!!

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message