Page Footer Date question

[Guy]

Hello,

I've created a report with a subform. The subform is displayed in datasheet
view and one of the fields is a date. I take the maximum date and print it
elsewhere on the report body. This works fine. The issue I'm having a problem
with is that I also need that date to appear in the page footer. This is not
working. It seems to be picking up data from the underlying table hundreds of
records away - as if Access cannot tell where it is. I can step through the
report, record by record and everything works perfectly except the page
footer. And I do not have a calculated field in the footer. As I step through
the report the page footer data changes, too.

Any suggestions? Thanks,
Guy

 

[Guest]

Add a text box to your report header section:
Name: txtMaxDate
Control Source: =Max([A Date])

Then add a text box to your page footer:
Control Source: =txtMaxDate

 

[Guy via AccessMonster.com]

Thanks for the suggestion. Sorry it took so long to get back to you but I'm
creating this app during my spare moments and wanted to test it before I
answered you.

It didn't work in the report header but worked from the page header. Also, it
works for all records except the first record. Not sure what it is that is
causing this.

Add a text box to your report header section:
Name: txtMaxDate
Control Source: =Max([A Date])

Then add a text box to your page footer:
Control Source: =txtMaxDate