Print the start date and end date on the report

[Scott]

I have a report based on a parameter query that asking for a start date and
a end date. I would like to print two dates on the title of the report.
Can someone advise how to accomplish it.

Thanks,

Scott

 

[fredg]

I have a report based on a parameter query that asking for a start date and
a end date. I would like to print two dates on the title of the report.
Can someone advise how to accomplish it.

Thanks,

Scott

Add an unbound text control to the Report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text with the brackets must be identical to the bracketed text in
the query criteria.

 

[Scott]

Fredg,

Many thanks! It works correctly.

Scott

I have a report based on a parameter query that asking for a start date
and
a end date. I would like to print two dates on the title of the report.
Can someone advise how to accomplish it.

Thanks,

Scott

Add an unbound text control to the Report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text with the brackets must be identical to the bracketed text in
the query criteria.