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...
 
Back
Top