I have an Access report whose recordsource is a query. I'm trying to use the max date function on MyDateField in the page header section of the report. When I do, I get an error. in the detail section of the report, it works fine but using it in a textbox in the page header section is producing an error. What am I doing wrong?
=Max([MyDateField]) <--- this is what the control source of my textbox looks like.