I have a report that works fine except that I want to show a reference in a control on the page header to the Month/Year the records were completed. I currently have the code below in the report. It works fine on the second page but not the first... which sort of makes sense to me because in the header of the first page it hasn't looked at the records yet... but I don't know how to make it work on the first page. Thanks in advance for your help!
="Material Costs - " & DatePart("m",[DateCompleted]) & "/" & DatePart("yyyy",[DateCompleted])
="Material Costs - " & DatePart("m",[DateCompleted]) & "/" & DatePart("yyyy",[DateCompleted])
