How to print date parameters on the report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Several of my reports are generated by setting a date parameter through a query. Is there a way to have this parameter print in the header of my report so everyone knows the date criteria that was used?
 
Several of my reports are generated by setting a date parameter through a query. Is there a way to have this parameter print in the header of my report so everyone knows the date criteria that was used?
Click to expand...

Add an unbound control to the report header.
Set it's Control source to something like:
="For sales between " & [Start Date] & " and " & [End Date]

The text within the brackets must be identical to the bracketed text
in the query criteria.
 
Thanks very much for your help
Nancy



fredg said:
Several of my reports are generated by setting a date parameter through a query. Is there a way to have this parameter print in the header of my report so everyone knows the date criteria that was used?
Click to expand...

Add an unbound control to the report header.
Set it's Control source to something like:
="For sales between " & [Start Date] & " and " & [End Date]

The text within the brackets must be identical to the bracketed text
in the query criteria.
Click to expand...
 

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
Show Parameter Information in Report Footer 1
Report Input Parameters 2
How do I print query parameters on the report? 2
Parameters in a Report 2
pass query parameter value to report 8
Dates and sub reports 5

Back
Top