Finding the maximum field value, over all records, ignoring found set
I am using the Max() function at table level to define a calculated global field to find the most recent entry in a date field. However, the displayed result is restricted to the current found set. I want to display the most recent date taken over all records in the database.
Can anyone help, please? Is there some function I can use at the table level to keep this global field updated, so that the displayed result is the same regardless of the current found set? Or am I doing it all wrong?