AnsweredAssumed Answered

Finding the maximum field value, over all records, ignoring found set

Question asked by MichaelMaggs on Jun 9, 2012
Latest reply on Jun 11, 2012 by philmodjunk

Title

Finding the maximum field value, over all records, ignoring found set

Post

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?

Outcomes