4 Replies Latest reply on Jun 11, 2012 10:31 AM by philmodjunk

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

    MichaelMaggs

      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?