Parameter Query in Report Header

S

Sarah G

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

How to display zero value in blank fields of Cross Tab query 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
print a date range from parameter query on a report header? 2
Creating a Chart on form from selected data in query. 0
How to automate update on weekly reports spreadsheet 0
pass query parameter value to report 8
Date Range in Header 1
Date Range in Header 1

Top