calculated field for most recent date

[vickiwells]

I have a field in a table which contains the date a record was last updated. Now I need a calculated field in a report header that will use that field to pull the most recent date out of all the records to use as my revision date for the report. Any ideas?

 

[Atomic Shrimp]

I've had to do something like this on a sales report in one of my databases, and found it simplest to create a subreport with just one text box for the last sale date, the subreport is based on the query:

SELECT Last(stores.lastSaleDate) AS LastDate
FROM stores;

the text box control source is then set to 'lastdate'

the advantage of this for me was that I could just paste the subreport into any of the many sales reports without having it interfere with the main report body.