Date revised

[lscheer]

I have a footer on many of my reports that indicates the date the report was last revised...but what it actually does is show the date the report was last printed. Since the report relies on a parameter query, and thus changes often, I doubt this is possible, but I was wondering if there's any way to get the date to read when the data was last updated?

 

[llkhoutx]

Do you keep track of when the data is revised? Use the BeforeUpdate event to save that date in a date field in the form where the data is updated. If the data is updated in a query, a a field to the query, inserting the date. You need that, then just before opening the report query for the max date, saving the value on a hidden form, then pick that value off the hidden form for your report.