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?
How can I make a field show the current date after any field in a record is updated? I found an article in the Microsoft Knowledgebase(Q96103) that was supposed to do it with a macro, but it doesn't work.