Access: Min function error on report page header

I am trying to get the min() and max() date of the current query to display on the Page Header section. My textbox is as follows

="Range date: " & Min([myDate]) & " to " & Max([myDate])

I am getting the #Error message on Access 2010 (MS Access 200开发者_运维百科3 file format, .mdb).

1. AFAIK, you can't use those in the page header, but you can use them in a group header/footer and in report header/footer. And you can force new page in a group headre/footer.
2. Otherwise, you will need a report level variable that you increment in the Detail_Format section, and that you reset in the PageHeaderSection_Format.
3. You could also have a control in the page header that refers to the one in the group header. That might be the easiest solution.

In the page header, you will need DMin and DMax, as far as I recall.

-- http://msdn.microsoft.com/en-us/library/aa159048(v=office.10).aspx

If I needed this, I'd tend to put it in the report's Recordsource, and then the values would be available anywhere in the report.