Parameter Query in Report Header

G

Guest

I have a Report which is based on a query with a date parameter. This
parameter is user defined. I need to display the dates chosen in the Report
Header eg "Report from XXXXX to XXXXXX"
 
F

fredg

I have a Report which is based on a query with a date parameter. This
parameter is user defined. I need to display the dates chosen in the Report
Header eg "Report from XXXXX to XXXXXX"
Click to expand...

Add an unbound text control to the Report Header.
Set it's control source to:
="Report from " & [Enter Start Date] & " to " & [Enter End date]

The text within the brackets must be identical to whatever the
bracketed text is in the query parameter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print a date range from parameter query on a report header? 2
Parameter Query In Report Title 3
Parameter Value as a Report Heading (Label/Text) 1
Report Header Lookup Question 2
Display query parameters in a chart 5
Pulling date from parameter 2
How do I reference a parameter in a report? 2
Date Range in Reports 2

Top