Include date range criteria in Report Header?

[templeowls]

Hi, so I have a report with a record source of a query which is utilizing a date range criteria. Basically, you input a start date and end date and the report shows all customer complaints during that time period.

>=[Start Date] And <=[End Date]

With that in mind, is there any way for the header of the report to include that date range that's selected?

Thank you

[Bob Fitz]

You could use a form from which you open the report. On the form you could have two textboxes to enter the StartDate and the EndDate which you could set a reference to in the reports criteria.

[pbaldy]

I'd also use a form, but this should work in a textbox:

="From " & [Start Date] & " to " & [End Date]