How to show User Input as part of the report title

[Russellh]

Hi,
So I use the >[Enter a Beginning Date] and < [Enter an End Date] to allow the user to enter the range they want to query for.
I would like to add this input to the report header. That way it will show what range the report is for once it is printed.

How would I do that?

[burrina]

Most apps have either a popup date form when the Report is opened or a date criteria form. Anyway, here is an example of the Report format.

="Job Details Report for the Time Period Between " & [Forms]![frmJobs]![StartDate] & " And " & [Forms]![frmJobs]![EndDate]

HTH

[Russellh]

This is just a query and a report created from the query. One column is say 'Bill Date'. in the design view under that column i enter >[enter start date] and ....
When the query or report is ran it pops up "enter start date" and after input it asks for end date. I'm not sure where it stores the input so that I can retrieve it.

I did not follow your code in the sense that where do the variables startdate and enddate come from?

[burrina]

The date criteria would come from in your case the query. Your Text Box on the Report would use this criteria as it's Control Source.