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 :)